Hi, I need to perform a query similar to
SELECT table1.a.b.x table1.a.c.x from table1; In this case "a" is an attribute in 'table1' and is a foreign key to other table2 which has 'b', and 'c' as attributes, which again are foreign keys to table3. Is there any simple way of doing this other than using the complicated nested joins which would include aliases also. SELECT table31.x table32.x FROM table1, table3 AS table31, table3 AS table32 WHERE table1.a = table2.id AND table2.b = table31.id AND table2.c = table32.id Thanks, Mukesh ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
