[Resolved] Left Join

[zzz]

I have been using syntaxt for LEFT JOIN to get data from two differenet tables. What would a syntax look like if I needed to access 3 tables at once?

Here's what i use now:

"SELECT * FROM table1 LEFT JOIN table2 ON (table1.item1 = table2.item2) WHERE item3= '$id'";

[ahundiak]

You can just keep adding as many joins as you want.
SELECT *
FROM table1
LEFT JOIN table2 ON (table1.item1 = table2.item2)
LEFT JOIN table3 ON (table1.x = table3.x)
WHERE item3= '$id

The * may give you some trouble especially if any columns share the same name. It's usually best to spell out exactly which columns you want.

[zzz]

I was thinking in the same direction but was not sure if it was allowed. Well, that makes my life a lot easier!