怎除找到的
select count(*) from #ddd d where not exists (select 1 from #ccc c where d.job_Number=c.job_Number)

delete from #ddd d where not exists (select 1 from #ccc c where d.job_Number=c.job_Number)

select....已找出的
delete...出,要怎修改除句？ 除找到的
[解决办法]
去掉#ddd 后面的 d 就可以了
delete from #ddd where not exists (select 1 from #ccc c where c.job_number = #ddd.job_number)