Select emails in one table that aren't in the other table

[charlie12345]

I'm sure this is simple, but I've never worked with two tables before. I'm trying to find all occurences where an email is in one table, and not the other.

Any suggestions or direction to some online help would be appreciated.

Charlie

 

[hvass]

The manual has a good lightweight introduction to databases and SQL

http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Tutorial

but you would need to dig a little deeper than the tutorial section in the manual to get the answer

select
a.email
from table1 a left join table2 b using(email)
where b.email is null;

This will give you a list of all emails in table1 that are not in table2

 

[swampBoogie]

select t1.* from t1
left join t2 on t1.email = t2.email
where t2.email is null

 

[charlie12345]

Thanks.
I thought it was a Join with 'is null', but I was missing something.