请问SQL SERVER如何实现多列NOT IN，谢谢
select exhibitionid,exhibitionnamecn,begintime,adddate,country from jdsh_Exhibition 
where ifimport <> 1 and (begintime,endtime,exhibitionnamecn) not in 
(select begintime,endtime,name from jdsh_Exhibition_web) order by exhibitionid desc

这是我的语句，ORACLE里支持多列IN，就可以执行，但是SQL SERVER就不行。请问该如何改，谢谢

------解决方案--------------------
楼主，sql多列not in也是可以的，用列名+列名+列名 这种方式就是可以了。很简单的。
------解决方案--------------------
随便一写，试试：
select a.exhibitionid,a.exhibitionnamecn,a.begintime,a.adddate,a.country 
from jdsh_Exhibition as a
where ifimport <> 1 
and not exists (select top 1 * from jdsh_Exhibition_web as b where a.begintime=b.begintime and a.endtime=b.endtime and a.exhibitionnamecn=b.name)
order by a.exhibitionid desc
------解决方案--------------------
更好的是:

SQL code

select a.exhibitionid,a.exhibitionnamecn,a.begintime,a.adddate,a.country 
from jdsh_Exhibition as a
where ifimport <> 1 
and not exists (select 1 from jdsh_Exhibition_web as b where a.begintime=b.begintime and a.endtime=b.endtime and a.exhibitionnamecn=b.name)
order by a.exhibitionid desc