What is Left Outer Join or Left JOIN
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.
SELECT select_List FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
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