MySQLFullJoin的實現

MySQLFullJoin的實現

MySQL Full Join的實現 因為MySQL不支持FULL JOIN,下面是替代方法
left join + union(可去除重復數據)+ right join

select * from A left join B on A.id = B.id (where 條件）
union
select * from A right join B on A.id = B.id （where條件);