SELECT * FROM TABLE1 A WHERE NOT EXISTS (SELECT 1 FROM TABLE2 B WHERE A.FIELD1=B.FIELD1 AND A.FIELD2=B.FIELD2 AND A.FIELD3=B.FIELD3)
我是这样写的,大家看有没错 select * from A where not (A.字段1 in(select B.字段1 from B) and A.字段2 in(select B.字段2 from B) and A.字段3 in(select B.字段3 from B) and A.字段xx = 0) ...
from ..
where
not (同时满足某种条件)
select
*
from tb
where
column1 not in()
and
column2 not in()
and
column3 not in()
--越不让用越用
SELECT * FROM TABLE1 A WHERE NOT EXISTS (SELECT 1 FROM TABLE2 B WHERE A.FIELD1=B.FIELD1 AND A.FIELD2=B.FIELD2 AND A.FIELD3=B.FIELD3)
select * from A where not (A.字段1 in(select B.字段1 from B) and A.字段2 in(select B.字段2 from B) and A.字段3 in(select B.字段3 from B) and A.字段xx = 0) ...
EXCEPT
select * from B