SQL LEFT JOIN Keyword

The LEFT JOIN keyword returns all records from the left table (table1), and the matching records from the right table (table2). The result is 0 records from the right side, if there is no match.

Example

 SELECT column_name(s)
 FROM  table1
 LEFT JOIN  table2
 ON  table1.column_name = table2.column_name;

Note:The LEFT JOIN is also called LEFT OUTER JOIN .

Demo Employee table

This employee table is used for examples:

Demo Products table

This product table is used in examples:

SQL LEFT JOIN Example

The following SQL statement will select all employee, and any orders they might have:

Example

 SELECT employee.Employee_name  , products.Product_id
 FROM  employee
 LEFT JOIN  products
 ON  employee.Employee_id = products.Product_id
 ORDER BY employee.Employee_name;

You can click on above box to edit the code and run again.

Output

Note: The LEFT JOIN keyword returns all records from the left table (employee), even if there are no matches in the right table (Orders).