Self Joins

[chergh]

I've got a table with a self join which represents a tree structure that can have variable depth.

I want to get a spreadsheet view of this for project review meetings. I can do a bunch of nested queries until I get all the branches but i would like something a little more dynamic, i.e. something that will automatically show the spreadsheet view of all branches no matter the depth of the tree.

So anyone got any suggestions on how to handle this?

 

[georgedwilkinson]

Use Oracle? http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:489772591421

Or, try to glean out how to do the same in Access by googling "hierarchical query Access" (good luck--everybody peppers the word "Access" throughout all their pages).

 

[Rabbie]

This link should help with self joins in Access

 

[georgedwilkinson]

I didn't think to ask, do you need the output in a hierarchical format (i.e. manager listed, all his direct reports next, interspersed with their direct reports, etc., then the next manager, etc.)?

If not, the link Rabbie supplied is the answer.