select trans.* from tr trans.....
where (trans.ID<>0 and trans.Status=@transStatus) and (t.DomainID=4) and t.ID not in
(select top 0 t.ID from .........)sqlserver2008
很困惑 为什么 select top 0 t.ID , 我测试发现单个表select top 0 t.ID总是空
t.ID not in (select top 0 t.ID from .........)到底代表什么意思??
where (trans.ID<>0 and trans.Status=@transStatus) and (t.DomainID=4) and t.ID not in
(select top 0 t.ID from .........)sqlserver2008
很困惑 为什么 select top 0 t.ID , 我测试发现单个表select top 0 t.ID总是空
t.ID not in (select top 0 t.ID from .........)到底代表什么意思??
有可能是你写错了!呵呵...ID not in (select top 0 t.ID )就是所有的ID啦...