数据库两表AB同结构或类似结构求 A-B /A n B / (A n B )的反集
例子:表A和表B都只有一个字段tel.
(A - B)
SELECT * FROM A left join B on A.tel=B.tel WHERE B.tel IS NULL
(A n B)
SELECT * FROM A left join B on A.tel=B.tel WHERE B.tel IS NOT NULL
(A n B )的反集
SELECT t1.tel as telA, t2.tel FROM t1 right join t2 on t1.tel=t2.tel WHERE t1.tel IS NULL
例子:表A和表B都只有一个字段tel.
(A - B)
SELECT * FROM A left join B on A.tel=B.tel WHERE B.tel IS NULL
(A n B)
SELECT * FROM A left join B on A.tel=B.tel WHERE B.tel IS NOT NULL
(A n B )的反集
SELECT t1.tel as telA, t2.tel FROM t1 right join t2 on t1.tel=t2.tel WHERE t1.tel IS NULL
扫一扫
3万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
