This is probably very easy but I seem to be struggling on this so hopefully some body can help.
I am trying to display results from field 'email' in table1, When I display the results I don't want table1.email to appear if it exists in table2.email.
So far I have tried these 2 statements:
SELECT test1.email FROM test1, test2 WHERE (test1.email != test2.email)
SELECT test1.email FROM test1 LEFT JOIN test2 ON test2.email = test2.email WHERE (test1.email != test2.email)
Hopefully somebody can help me out.