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@heart.com.au