DavidSzczesniak
1/24/2018 - 5:44 PM

EXCEPT keyword

Returns distinct rows from the first SELECT statement that aren't ouput by the second SELECT statement.

\!h Format:
SELECT column_name(s) FROM table1

EXCEPT

SELECT column_name(s) FROM table2;

-- Example: merging old product data with the new.
-- we want to see if there are any categories that are in the old one, that the new one is missing.