Should I use NOT IN, OUTER APPLY, LEFT OUTER JOIN, EXCEPT, or NOT EXISTS? SQL Sentry's Aaron Bertrand (@AaronBertrand) digs into the left anti semi join, comparing NOT IN, NOT EXISTS, OUTER APPLY, EXCEPT, and OUTER JOIN methods. Aaron Bertrand ◆ December 27, 2012 27