select supplier_id
,t1.contact_id
,t1.first_name
,t1.last_name
from username
,(select distinct contact_id, first_name, last_name
from contact
where contact_id in (select distinct contact_id
from contact
group by email
having count(*) > 1)) t1
where t1.contact_id=username.contact_id;