PostgreSQL Outer Join
The Outer Join is an extension of Inner Join. There are three types of Outer Joins.
Left Outer Join:
The left outer join returns all rows from the left hand table specified in the "ON" condition and only rows from the other table where the condition is fulfilled.
See this example:
Let's take a table "EMPLOYEES" having the following data.
Create another table "DEPARTMENT" having the following data.
Execute the following query: