MySQL的内部联接对面

select email from Email_Table t1 where not exists (select email        from Contacted_table t2        where t1.email = t2.email)

或者

select email from Email_Table t1 where email not in (select email          from Contacted_table)