22,210
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#A') is null
drop table #A
Go
Create table #A([COL1] nvarchar(21),[COL2] nvarchar(22))
Insert #A
select N'a',N'sz' union all
select N'd',N'gz'
GO
if not object_id(N'Tempdb..#B') is null
drop table #B
Go
Create table #B([COL1] nvarchar(21),[COL2] nvarchar(25))
Insert #B
select N'a',N'sz,gz' union all
select N'd',N'sz,ah'
Go
--测试数据结束
SELECT *
FROM #A
WHERE NOT EXISTS ( SELECT *
FROM #B
WHERE CHARINDEX(',' + #A.COL2 + ',', ',' + #B.COL2 + ',') > 0
AND COL1 = #A.COL1 )