请教个sql语句

[Mark杨]

select SUM(mony) from table1 where part not in ('电修','机修')
这有结果
declare @a nvarchar(200)
select @a = parts from table2
print @a -->'电修','机修'
select SUM(mony) from table1 where part not in (@a)
没结果了

[htl258_Tony]

declare @a nvarchar(200)
select @a = parts from table2
print @a -->'电修','机修'
select SUM(mony) from table1 where charindex(','+part+',',','+@a+',')=0

[黄_瓜]

declare @a nvarchar(200)
select @a = parts from table2
print @a -->'电修','机修'
exec('select SUM(mony) from table1 where part not in ('+@a+')')

[htl258_Tony]

或者:

declare @a nvarchar(200)
select @a = parts from table2
print @a -->'电修','机修'
EXEC('select SUM(mony) from table1 where part not in ('+@a+')')

[东那个升]

只能UP了

[黄_瓜]

declare @a nvarchar(200)
select @a = parts from table2
print @a -->'电修','机修'
exec('select SUM(mony) from table1 where part not in ('''+@a+''')')