Javatpoint Logo
Javatpoint Logo

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.

PostgreSql full join1

Syntax:

See this example:

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

Table1: EMPLOYEES

PostgreSql full join2

Create another table "DEPARTMENT" having the following data.

Table2: DEPARTMENT

PostgreSql full join3

Execute the following query:

Output:

PostgreSql full join4



Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


B.Tech / MCA