select * from table1 left join table2 on 条件1 left join table3 on 条件2 left join table4 on 条件3 where 条件4