>Yes, the "null" method blew my mind when I first encountered it (in an example much more complex, using a join Select). Using it has trimmed 80% off the SQL times (against SQL Server 2014) in our large queries, compared to IN SELECT. SQL Server, for one, produces the same Query Plan for EXISTS and IN SELECT, in case anyone is wondering.
>
In SQL Server, why wouldn't you use the EXCEPT keyword?
SELECT iID FROM Table2
EXCEPT
SELECT iID FROM Table1
http://www.tomorrowssolutionsllc.com/Articles/Combining%20Query%20Results.pdfTamar
