LEFT OUTER JOIN

Database Dictionary -> LEFT OUTER JOIN

LEFT OUTER JOIN

The LEFT OUTER JOIN known also as LEFT JOIN returns all rows from the left table in the LEFT OUTER JOIN clause, not matter if the joined columns match. If a row in the left table (first table) doesn’t match a row in the right table (second table), the returned value for the second table is set to NULL.

SQL Tutorial