OUTER JOIN

There are three different Outer Join methods
LEFT OUTER JOIN.
This join returns all the rows from the left table in conjunction with the matching rows from the right table. If there are no columns matching in the right table, it return NULL values
http://www.pinaldave.com/bimg/march09ug/left%20join.jpgs .

in reference to:

"This join returns all the rows from the left table in conjunction with the matching rows from the right table. If there are no columns matching in the right table, it returns NULL values."
- SQL SERVER – Introduction to JOINs – Basic of JOINs « Journey to SQL Authority with Pinal Dave (view on Google Sidewiki)