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)

Share on Facebook0Tweet about this on Twitter0Share on Google+0Pin on Pinterest0Share on LinkedIn0Share on Reddit0
It's only fair to share...

Add Comment

Required fields are marked *. Your email address will not be published.