Returns rows that are in an initial SELECT statement, but not in a secondary query.
TABLE1 has one field with the following data: a,b,c,d,e,f,g
TABLE2 contains: c,d,f,x,z,
SELECT * FROM TABLE1 EXCEPT SELECT * FROM TABLE2
Results in the following: a,b,e,g
Please sign in to leave a comment.