mysql中实现oracle中的full join

MySQL Full Join的实现 因为MySQL不支持FULL JOIN,下面是替代方法
left join + union(可去除重复数据)+ right join

select*from Aleftjoin Bon A.id = B.id (where 条件）
union
select*from Arightjoin Bon A.id = B.id （where条件);