Is the same Select Company.*, email.email, phone.phone FROM Company LEFT JOIN email ON Company.ID = email.companyID AND Company LEFT JOIN phone ON Company.ID = phone.companyID If the phone or the email for that company don't exist, you will see the field like NULL. Cheers!!!! Carlos Antollini.