1.如果A和B只要比较一个字段 ,可用 in
SELECT *
FROM A
WHERE A.columx not in
(SELECT B.columy From B)2.如果A和B比较多个字段 ,可用Exists
SELECT A.*
FROM A
WHERE NOT EXISTS
(SELECT * FROM B
WHERE A.Columx1=B.Columy1 AND A.Columex2=B.Columy2 AND ...)
SELECT *
FROM A
WHERE A.columx not in
(SELECT B.columy From B)2.如果A和B比较多个字段 ,可用Exists
SELECT A.*
FROM A
WHERE NOT EXISTS
(SELECT * FROM B
WHERE A.Columx1=B.Columy1 AND A.Columex2=B.Columy2 AND ...)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货