If I have the following 'Hierachy' table...
Child | Parent
--------------
1 | 0
2 | 1
3 | 1
4 | 3
5 | 4
6 | 3
7 | 4
How do I return a list 5,4,3,1 ?
SELECT a.Child FROM Hierachy AS a, Hierachy AS b
WHERE a.Parent = b.Child
AND a.Child = 5;
... is obviously a bit simplistic in my approach.
--
Keith Gray
Technical Development Manager
Heart Consulting Services P/L
mailto:keith(at)heart(dot)com(dot)au