如果查询这几段字符串不在某字段中？

[yyyrrr51]

"A0001","A0002","B0020","C0020"
以上是程序产生的一些字符串，怎么用一句语句判断哪个字符串不在数据库某字段中？

因为我想判断上面哪些是入库的，哪些是没入库的，没入库的取出来。

select * from tb where fd not in ("A0001","A0002","B0020","C0020")显然是不行,这句只是显示fd里不包含上面字符串的数据，列出这句主要是想提示不要误会我的意思。

注意，要反过来

[jinjazz]

select * from (select 'A0001' as fd union 
	select 'A0002' union select'B0020' union select'C0020')t 
where fd not in(select fd from tb)

[-狙击手-]

declare @s varchar(1000)
set @s = '"A0001","A0002","B0020","C0020"'
set @s = replace(@s,'","' ,''' as col union all select ''')
set @s = 'select '+replace(@s,'"' ,'''')
set @s = 'select col from ('+@s+'
) a where not exists(select 1 from tb where fd = a.col)'


exec( @s)

[lihan6415151528]

select * from (select 'A0001' as fd union 
    select 'A0002' union select'B0020' union select'C0020')t 
where fd not in(select fd from tb)

[水族杰纶]

--try
declare @str varchar(8000)
set @str=',A0001,A0002,B0020,C0020,'
select * from tb where charindex(','+fd+',',@str)=0

[yyyrrr51]

忘了说我是在Access里，上面语句似乎都不行

[sharelove]

上邊的方法雖不行，但可以提供給你思路！

[linguojin11]

思路应该是首先将字符串整合到一A表中，然后判断A字段值是否存在与B表中的字段中。。。
石头大哥的UNION句也是这种原理