Thanks all to make effort for me.

This one does work for me just perfect.

Once again thank you all and i really appreciate all the help... with 🙂

Thanks you alll...

Above one is just perfect for my problem. And i will make my changes according to specification.

Thanks for making efforts for me... I appreciate all the work...

Hello,

SELECT *

FROM TABLE_A AS A

LEFT JOIN TABLE_B AS B ON A.A_ID = B.A_ID

is not something i am looking for. as this query repeats the value...

Oopps i just see that i post this at wrong place. let me find correct thread and post there. i will wait here for any answers as well..

Sorry folks.