actually, it is ANSI SQL

however, a great number of problems posted in this thread are actually looking for a dbms-specific solution, not an ANSI SQL one



i don't know why your NOT IN didn't work either, the only thing i can think of is trailing spaces in the data values

but if you're happy with EXCEPT, that's fine

EXCEPT is ANSI SQL too