left join =left outer join -----返回满足条件的table1的全部记录,无论table2是否满足 inner join 跟平常的多表关联查询差不多,要table1和table2同时满足条件