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.

Syntax:

See this example:

Let's take a table "EMPLOYEES" having the following data.

Table1: EMPLOYEES

Create another table "DEPARTMENT" having the following data.

Table2: DEPARTMENT

Execute the following query:

Output: