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