摘要： select t1.* from table1 t1 where not exists (select t2.c1 from table2 t2 where t2.c1 = t1.c1)select t1.* from table1 t1where t1.c1 not in (select t2.c1 from table2 t2)truncate table dbo.Employe1 --快速... 阅读全文