The "select not in" statement doesn't seem to work in mysql... Is there an equivalent?
I already came across the LEFT JOIN but I don't like such a solution.
Is there an easier way?
SELECT email FROM tblusers
WHERE email NOT IN (
SELECT email FROM tblclients);