LEFT OUTER JOIN
Database Dictionary
-> LEFT OUTER JOIN
Search:
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