Doh! I was afraid that this is what you wanted! :)

I don't know of any simple way to get that information. You could keep doing LEFT OUTER JOINs for, say, 5 generations, but that would be an arbitrary limit.

Maybe you could check at the Solutions example on the treeviews. It might give you another insight as to how to display your data.

>OK, Sylvain, we are almost there. Thanks very much for your help.
>
>What I need now is:
>
>SQL 1 must return multiple generations: ie children, grandchildren, greatgrandchildren, ...
>
>SQL 2 must return multiple generations of ancestors: ie parent, grandparent, great-grandparent, ...