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條件);
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條件);