[SOLVED] 3 Table Left Join

[rubing]

I run mysql 5.0.45.

 

This LEFT JOIN works fine, on my two tables:

 

SELECT tableA.colA,tableA.colB,tableB.colA,tableB.colB,tableBcolC 
FROM tableA LEFT JOIN tableB ON tableA.colA=tableB.colB
WHERE Date = '2008-05-20' ORDER BY tableBcolB ASC"; 

 

However I now want to add a third table to this LEFT JOIN, such that TableB.colD = TableCcolB.  Do I need to use a different Syntax to do this?

[rubing]

Just found the answer here:

 

http://www.wellho.net/solutions/mysql-left-joins-to-link-three-or-more-tables.html