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的高,不知道對不對?
...全文
1985打赏收藏
下面兩句SQL誰的效率高?
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的高,不知道對不對?