Originally Posted by fff398
oh sorry didn't realize NOT IN was exclusive to only sql server?
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