LEFT OUTER JOIN or LEFT JOIN
JOIN is equivalent to
Check THIS example.
Since it returned the rows we can assume that's a
Specifies all matching pairs of rows are returned. Discards unmatched rows from both >tables. When no join type is specified, this is the default.
Also, according to this post the JOIN clause is optional:
For instance, the entire type-part of the JOIN clause is optional, in which case the default is INNER if you just specify JOIN.