subject:"\[SQL\] Alias Join Table"

Re: [SQL] Alias Join Table

2001-10-04 Thread Josh Berkus

Keith, There are a number of posts and papers on tree structures , both in the SQL list archives, and on Roberto Mello's resources at techdocs.postgresql.org. -Josh __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete informati

[SQL] Alias Join Table

2001-10-04 Thread Keith Gray

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