编写sql语句 左连接 union all 右连接 就是全连接,如
select * from A left join B on A.id=B.idunion all select * from A right join B on A.id=B.id