Compare to fields from two different tables with same structure

[Tbell]

Hello
I admit I am somewhat of a beginner at this, but I am amazed as to why none of the examples and other help I have found have allowed me to get this working.

I have two tables, table1 and table 2, with the following fields in them both
Email, Date, ID

now what I want to do, is compare the two tables and find the differences, so i can get them matching up. The easy was would be to just copy one from the other, but due to various unforseen reasons, they now differ and I need the data that is different from them, so i can make a complete list over the emails in them both.

I have tried a few things, among others
select Email
from table1
where not exists(select Email from table2 where table2.Email =
table1.Email)

Now Im sure this is wrong, but nothing I have tried works, and I have been all over google,trying probably 50 different ones now, and I cant get anything to work. Im most likely doing it wrong, but I was hoping someone would show me the error of my ways.

Thanks
Regards
Tommy

[iburyak]

Did you try this?


[PHP]select Email
from table1
where not exists(select Email
from table2
where Email = table1.Email
and Date = table1.Date
and ID = table1.ID)[/PHP]