mysql(inner join)(left outer join 、right outer join )使用 假设有两个表 a,b inner join select * from a inner join b on a.id = b.id 查询出有相同值的结果 left join select * from a left join b on a.id = b.id a表全部查询出来了 b表只查询出相同值的结果 right join select * from a right join b on a.id = b.id b表全部查询出来了 a表只查询出相同值的结果