SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN | Journey to SQL Authority with Pinal Dave

The EXCEPT operator returns all of the distinct rows from the query to the left of the EXCEPT operator when there is no matching rows in the right query. The EXCEPT operator is equivalent of the Left Anti Semi Join. EXCEPT operator works the same way NOT IN. EXCEPTS returns any distinct values from the… Continue Reading...

Source: SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN | Journey to SQL Authority with Pinal Dave