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
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
本文标题：SQL剔除重复部分后的合集
本文链接：https://www.haomeiwen.com/subject/vihnkdtx.html
网友评论