Left Join 语法:
|select * from|
|table1 left join table2 on 条件1 |
|left join table3 on 条件2 |
|left join table4 on 条件3 |
|where 条件4|