Puoi fare in questo modo:

codice:
SELECT CONTATTI.email
FROM CONTATTI left outer join USER
on CONTATTI.email = USER.email
WHERE USER.email is null;