sql左连接、右连接

select a.* from a left join b on a.bId = b.bid 就是查询出a表的全部，b表中没数据的字段为空显示

a left join b 等于 b right join a