SQL剔除重复部分后的合集
2023-02-20 本文已影响0人
闪闪亮晶晶mi
image.png
select * from a left join on a.useid = b.userid where b.useid is null
union
select * from a right join on a.useid = b.userid where a.useid is null
select * from a left join on a.useid = b.userid where b.useid is null
union
select * from a right join on a.useid = b.userid where a.useid is null
