What is Left Outer Join or Left JOIN
with Example?
The LEFT OUTER JOIN /LEFT JOIN returns all records from the left table and the matched records from the right tableÂ
A = B (+)
If no matching rows found in the right table, NULL are used.
Syntax
SELECTÂ select_List FROMÂ table1
LEFTÂ JOINÂ table2Â
ON table1.column_name = table2.column_name;
Example:
Consider Employee table having below records.
Consider Department table having below records.
List all Employees and their department irrespective whether they belongs to any department or not
Select e1.EmployeeID ,e1.Employee_FirstName ,e1.Employee_LastName ,e1.City , d.departmentID , d.departmentNameÂ
from Employee e1 LEFT JOIN Department d
ON e1.departmentID=d.departmentID order by departmentID
