Full Outer Join
The FULL outer join returns all rows from the LEFT-hand table and RIGHT-hand table both. It puts NULL in place where the join condition is not satisfied.
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: