CREATE TABLE #T1(ID INT) CREATE TABLE #T2(ID INT)INSERT INTO #T1 SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 INSERT INTO #T2 SELECT 1 UNION ALL SELECT 2 SELECT *FROM #T1 WHERE ID NOT IN(SELECT ID FROM #T2)
select * from a t where not exists(select 1 from b where id=t.id)
select * from a t where not exists(select 1 from b where id=t.id)
select * from A where not exists (select * from B where A.主键 = B.主键) 这样就可以查找出来了
CREATE TABLE #T2(ID INT)INSERT INTO #T1
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 4 UNION ALL
SELECT 5
INSERT INTO #T2
SELECT 1 UNION ALL
SELECT 2 SELECT *FROM #T1 WHERE ID NOT IN(SELECT ID FROM #T2)
from a t
where not exists(select 1 from b where id=t.id)
from a t
where not exists(select 1 from b where id=t.id)
这样就可以查找出来了