Re: Having a mental block with (self) outer joins

> If the table contains more levels (i.e. child1 being the parent of 
> another item) this bring others back as well. And I was trying to 
> retrieve the full path for each item (I do know the max. number of
levels)
> 

There is no max number of levels.  I don't try to pick all the levels 
out in one query though.  In my case, since I don't know the number of 
levels, I do the query recursively.  This works just fine to build a 
complex tree but you might consider caching the results.

-Dennis