PostgreSQL Full Join

All the matched and unmatched records are retrieved from the both the tables present in the query.Full Join is used to return all data or records when a match occurs in a Table 1 or Table 2 record and NULLs have to be filled in for missing matches on either side. It is also known as Full (OUTER) JOIN.

Full Joins Syntax :

The syntax of the Full Joins statement is −

SELECT col_name,...
FROM table_name1 t1  [FULL] JOIN table_name2 t2
ON t1.col_name = t2.col_name

PostgreSQL Full Join Example :

Consider the Customer table with the following records -

Consider the Order table with the following records -

TEST CASE 1 :-Let us join these two tables using the Full JOIN as follows

SELECT  ID, Name, Amount, Date
FROM Customer
FULL JOIN Order
ON Customer.ID = Order.Customer;

The result for the respective PostgreSQL query is as follows −

---

Visit :

---

Discussion