left joining more than 2 tables

[madrav72]

Hi whats the syntax for left joining more than 2 tables if each of the tables has a common column???

 

[macca the hacke]

SELECT
FROM (Table1 LEFT JOIN Table2 ON Table1.column1 = Table2.column1) LEFT JOIN Table3 ON Table1.column1 = Table3.Column1;

 

[Jibbadiah]

madrav72,

A wee tip... create the query in design view.
You can double click the line that joins the 2 tables (to change the join properties). This allows you to create an inner join, right join or left join...

Once you have done this you can then click on SQL view to see the new syntax.

J.

 

[madrav72]

Macca the Hacca i tried your syntax but it seems to have problems with it - it keeps point to eliminate the third table name from the sql code - syntax error in join operation