Hi Mufasa,
I have encountered one more problem here. There are some rows in child which do not have any relation with parent i,e id1,id2 and id3 are blank. How can i modify the above query so that it will fetch all those child rows which do not have any relation with parent.
Regards,
Danny !