The LEFT OUTER JOIN or simply LEFT JOIN return all rows from the first table listed after the FROM clause or left of JOIN keyword , no matter if they have matches in the right table of the JOIN keyword. Syntax : FROM table1 LEFT OUTER JOIN table2 ON table1.column_name=table2.column_name ; Check here lot of examples : http://www.w3resource.com/sql/joins/perform-a-left-join.php