I am sure there are several post for this but I haven't found one I really understand yet. I have a hierarchy table with 3 columns in it ParentID, Description, ChildID. I would like to use a query to get all of the ChildIDs and its childIDs from a ParentID. I know this is simple but I just don't get it.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
hierarchy table
- Thread starter testeng
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question