Query to compare 2 tables

[richardrekos]

I have 2 small tables (one column) that contain email addresses. I want to compare the tables to find out which email addresses match up between the 2 tables. Is there a simple way to query for this?

Thanks,

Rich

 

[amrita418]

Join the tables on emailaddresses:

select a.emailaddress, 
       b.emailaddress
from   tableA a 
       inner join TableB b 
       on (a.Emailaddress = b.EmailAddress)

Regards,
AA

 

[bborissov]

SELECT Table1.EMail, Table2.EMail FROM Table1
LEFT JOIN Table2 ON Table1.eMail = Table2.eMail
WHERE NOT Table2.eMail IS NULL

(not tested)

Borislav Borissov

 

[richardrekos]

Cheers to you both.