  FROM Contacts contact LEFT JOIN Company company ON company.Cntct_id=contact.Cntct_id  UNION  SELECT Contact,Company  FROM Contacts contact RIGHT JOIN Company company ON company.Cntct_id=contact.Cntct_id;  Contact     Company ============================== Contact 0   Company 0 Contact 0   NULL Contact 0   NULL 