A表的NAME字段和B表的NAME字段相同,查询
A表中NAME项不在B表中的NAME项的记录。
select name
from
A
where
name
not
in
(
select
name
from
B)
或者
select A.NAME
from A left join B ON A.NAME=B.NAME
WHERE B.NAME IS NULL
还可以附加条件
select A.NAME
from A left join B ON A.NAME=B.NAME and B.xid=1
WHERE B.NAME IS NULL