), like this: SELECT Contact,Company   FROM Contacts contact  RIGHT JOIN Company company ON company.Cntct_id=contact.Cntct_id;  Contact     Company ============================== Contact 0   Company 0 NULL        Company 0 NULL        Company 0