select tableA.column1, tableB.column1, tableC.column1 

from table1, table2, table3 

where table1.column1 =3D table2.column1 

and table2.column1 =3D table3.column1

you can select more columns from any tables, and from any tables.  Rememb
er in
where clause, you need number of tables you selected minus 1 conditions t
o
join them together, otherwise you will do cartesian joint.

for example, you want joint 3 tables, you need 2 conditions for join 3 ta
ble
together.

Li Li



"Brian McAteer" <brian@m...> wrote:
Is it possible to join more than two tables together in the one SQL 

statement?

If so, what would the syntax look like.

Thks in advance.