LEFT JOIN more than 2 tables?

[Anon]

OK, I have three tables: tb1, tb2, tb3 with fields below:
+ tb1: id, id1, id2 (main table)
+ tb2: id1
+ tb3: id2
How to make a select statement with left join three tables, display all fields in three tables? In 'id1' and 'id2' in table tb1, one of them will be zero in a record. That means there is no record in tb2 or tb3 for the id1 or id2 if equals zero. The result should have the same number of record as in tb1. If a record doesn't exist in tb2 or tb3, all fields in that table must be null. Please help. Thanks.

[Anon]

That would something like:

SELECT t1., t2., t3.* FROM tb1 AS t1 LEFT JOIN tb2 AS t2 ON t1.id1=t2.id1 LEFT JOIN tb3 as t3 ON t1.id2=t3.id2;

docs:
http://www.mysql.com/doc/J/O/JOIN.html

[Anon]

thanks