http://www.dofactory.com/sql/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 returns NULL values. Example - Select * From Table1 LEFT Join Table2 ON table1.ColumnName = Table2.ColumnName