from A right join B on A.id = B.id （where条件);
MySQL Full Join的实现
标签：
MySQL Full Join的实现
* from A left join B on A.id = B.id (where 条件）
union
select *