Mysql NOT IN To use IN, you must have a set, use this syntax instead: SELECT * FROM Table1 WHERE Table1.column NOT IN (SELECT column FROM table2) 000000It's only fair to share... December 27, 2013 admin MySQL Leave a Comment