LEFT JOIN more than one table?

Anon

How to join 3 tables together in MySQL? Like if I have table A,B, and C with same field 'id', how to get those record with same 'id'?
Thanks

Anon

select * from a left outer join b using (id) left outer join c using (id)

Anon

what is the differences between "left outer join" and just "left join" because "left join" gave me an syntax error!!??

Anon

No difference at all. Outer is an optional keyword according to ANSI SQL.

Just another unwarranted standard deviation, typical to Mysql.

Anon

Yes, I was wrong, there is no error if I take away "outer" and the result is the same. However, let's me clearify a little. OK, in 3 tables: A,B and C:
+ 'id' in A is primary, means unique
+ 'id' in B and C is not unique.
+ There is always at least one 'id' in B as same in A. However, 'id' in C is not necessary to be exist as same as 'id' in A.
+ The query will get a record in B if 'uid'=1
+ The query will get a record in C if 'uid'=1
or not exist.
Wow, now it's a big problem to me. Please help me again. This is too hard.

Anon

To pursue a little more, would\'nt this do the same?

SELECT *
FROM A, B, C
WHERE
A.id = B.id
AND B.id = C.id

Peter

p.s. By the way I should always specify the fields to be selected instead of *

Anon

As I read it, he wants the rows from a and b even if there is no row in c with the corresponding id.

The LEFT JOIN that Lars gave the first time should work. This is an INNER JOIN and won't return anything if the id isn't in table c.

Anon

Yes, I finally got it. Thanks all.

mattr

LEFT JOIN != INNER JOIN. LEFT/RIGHT joins will produce a joined table that includes all rows from the outer table, regardless of whether the on clause produces matching rows or not. This is quite different than INNER JOINs, which require matches for both rows to be returned.