• Thank you LutzM.

    Can you also tell me how to get the CustomerID in the resultset ?

    SO the output should looks like:

    A8339 123456

    A8339 7890123

    Thank you all.