How to get child's child record through query
Posted on 2007-03-19
I have a table with 3 fields say ItemID, ParentID and ItemName
It has parent child relationship. So for some Items a different ItemID will be in ParentID.
and there is no limit to how long a parent child chain can go...i mean a item can have a child which had another child and that has another child like that....
What i need to find out through query is...if i pass a parentID i need to get all the child and their child and their child ITEMIDs...
How can we do it through query....