Got it thank u:-)

Thank you it works:-)

I tried but sequence is not correct 1012345 is child of 1055872 then 1012345 has to become a parent but result is not like that. It has to return like...

Thank you kingston it works but if i want to get more than 1 product details (i.e. 1055874 , 1055872 , etc. ) then how to change the query.

Dear Sean Lange & SSC Rookie,

Thanks for your reply.I cant able to show my table in this forum. Can you tell me how to add image in...