SELECT id FROM tabellaA AS o JOIN tabellaB AS c WHERE c.email = o.email

ora?