SQL FULL OUTER JOIN

The SQL FULL OUTER JOIN joins two tables based on a common column, and selects records that have matching values in these columns and remaining rows from both of the tables.

Syntax:

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name
WHERE condition;

Customers table:

Orders table:

Here, the SQL command selects customer_id and fullname columns (from the Customers table) and the amount column (from the Orders table).

QUERY:

SELECT Customers.customer_id, Customers.fullname, Orders.amount
FROM Customers
FULL OUTER JOIN Orders
ON Customers.customer_id = Orders.customer;

And, the result set will contain those rows where there is a match between customer_id (of the Customers table) and customer (of the Orders table) along with all the remaining rows from both of the tables.

Result: