You need to use an outer join in this kind of situation. Outer join returns rows from a table even if it has no corresponding rows in the joined table.
The outer join can be a left outer join or a right outer join depending on the order you list the tables.
Have a look at all of the join examples in
SQL Joins[
^], especially
SQL LEFT JOIN[
^] and
SQL RIGHT JOIN[
^]