[Resolved] joining 3 tables on 2 different fields

[BigE]

I want to join Table1, Table2, and Table3. Table1 has a field in common with Table2, and Table2 has a field in common with Table3. Table3 has no fields in common with Table1.

Table1 has fields A,B,C
Table2 has fields C,D,E
Table3 has fields E,F,G

I want to join all three tables via fields C and E.

Can this sort of join be done? I have been struggling mightily with the syntax.

Regards,

E

[Lars_Berg]

select <columnsOfInterest>
from table1,table2,table3
where table1.c = table2.c
and table2.e = table3.e

[BigE]

Oh man. That is so simple. Thank you so much. Here I am fighting with joins and aliases. Sometimes you look so hard for the difficult solution you miss the obvious one.

Thanks again.

-E