OUTER JOIN

SQL FULL OUTER JOIN Keyword

The FULL OUTER JOIN command is used to return all rows from both tables. If there is no match, the result will contain NULL on the side where there is no match.

SQL FULL OUTER JOIN Syntax

SELECT column_names
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name;

SELECT column_names

FROM table1

FULL OUTER JOIN table2

ON table1.column_name = table2.column_name;

SQL FULL OUTER JOIN Customers and Orders Example

This query selects all customers and all orders. Where there is no match, NULL values will fill in the missing side.

SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
FULL OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
ORDER BY Customers.CustomerName;

SELECT Customers.CustomerName, Orders.OrderID

FROM Customers

FULL OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

ORDER BY Customers.CustomerName;

Note: The FULL OUTER JOIN keyword returns all records from both tables. If there is no match, missing values will appear as NULL.

Important: FULL OUTER JOIN is not supported in SQLite and therefore will not work in the TechKubo playground. Use LEFT JOIN, RIGHT JOIN, or simulate with UNION if needed.

SQL FULL OUTER JOIN Labs