Not VB6 - Access but can anyone help?

[Caro]

I have an SQL in Access which creates a recordset of fields from different tables depending on matches. For example if a 'Contact Name' in a query is equal to one in my 'Contact table' - I am selecting the phone numbers for the contact. What happens is that if there is no match I don't get anything selected. I want to select everything else and if the contact doesn't match, just have null fileds for phone numbers - does anyone know how to do this with an SQL?

[JHausmann]

"Join". A full join will return all records from both tables, a right (or left) join will return all the data on the right (or left) side of the join statement, even if the other side has no matching records.