As alrady mentioned, JOIN referes to INNER JOIN on default, you might want to look into LEFT joins, which ignore rows that don't have data instead of keeping them null.

The other is RIGHT JOIN, which is actually not used, (Its nearly identical to LEFT JOIN)