select b.* from a Right Join b on a.a=b.a and a.b=b.b and a.c=b.c
select * from #t where not exists (select * from #t1 where #t1.a=#t.a and #t1.b=#t.b and #t1.c=#t.c)
nnd,剛剛想出來了,分沒有了~跟ls的一樣
select a.* from a where cast(a as varchar) + ',' + cast(b as varchar) + ',' + cast(c as varchar) not in (select cast(a as varchar) + ',' + cast(b as varchar) + ',' + cast(c as varchar) from b)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货