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就不行。请问该如何改,谢谢
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就不行。请问该如何改,谢谢
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
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