SELECT * FROM employee WHERE [emp_no] NOT IN (SELECT [emp_no] FROM tmpHR)SELECT a.* FROM employee a left join tmpHR b on a.[emp_no]=b.[emp_no] where b.[emp_no] is null個人認為left join 的比Not in的高,不知道對不對?
调试欢乐多
WHERE not exists (SELECT 1 FROM tmpHR where [emp_no]=A.[emp_no])