34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM #taba AS a WHERE NOT EXISTS(
SELECT 1 FROM #tabb AS b WHERE a.id=b.id
)
借用雨亭的数据
--测试数据
CREATE TABLE #taba(
id VARCHAR(20)
)
INSERT INTO #taba
SELECT 'a' UNION ALL
SELECT 'b' UNION ALL
SELECT 'd' UNION ALL
SELECT NULL
CREATE TABLE #tabb(
id VARCHAR(20)
)
INSERT INTO #tabb
SELECT 'a' UNION ALL
SELECT 'b' UNION ALL
SELECT 'c' UNION ALL
SELECT NULL
--测试数据结束
select * from #taba where id in (select id from #tabb)
select * from #taba where id not in (select id from #tabb)
select * from #taba where isnull(id,'') not in (select isnull(id,'') from #tabb)