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…