select中in和not in
select count(job_Number) from #ddd
select count(job_Number) from #ccc
select count(*) from #ddd d where d.job_Number in (select job_Number from #ccc)
select count(*) from #ddd d where d.job_Number not in (select job_Number from #ccc)

分返回
584080
50286
277130
0

在什in有，not in 有呢？

[解决办法]
select count(*) from #ddd d where not exists (select 1 from #ccc where d.job_Number=job_Number)