I need to get the supplier name and their supplier contact if they have the duplicate email address.
The following are the three tables: supplier, username and contact

SUPPLIER USERNAME CONTACT
-------- --------- -------------
supplier_id username_id contact_id
name supplier_id first_name
contact_contact_id last_name
email

I have the following query to get the duplicate supplier_id and email address but how can I modify the query to include the contact.first_name and contact.last_name.

select s.supplier_id , c.email from supplier s, username u, contact c
where s.supplier_id = u.supplier_id and
u.contact_contact_id = c.contact_id
group by s.supplier_id, c.email
having count(*) >1