{"id":601,"date":"2024-09-02T06:55:39","date_gmt":"2024-09-02T06:55:39","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=601"},"modified":"2025-06-03T13:22:40","modified_gmt":"2025-06-03T13:22:40","slug":"outer-join","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/outer-join\/","title":{"rendered":"OUTER JOIN"},"content":{"rendered":"\n

SQL FULL OUTER JOIN Keyword<\/h2>\n\n\n\n

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.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL FULL OUTER JOIN Syntax<\/h2>\n\n\n\n
SELECT column_names\nFROM table1\nFULL OUTER JOIN table2\nON table1.column_name = table2.column_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL FULL OUTER JOIN Customers and Orders Example<\/h2>\n\n\n\n
This query selects all customers and all orders. Where there is no match, NULL values will fill in the missing side.<\/p>\n\n\n\n
SELECT Customers.CustomerName, Orders.OrderID\nFROM Customers\nFULL OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID\nORDER BY Customers.CustomerName;<\/pre><\/div>\n\n\n\n
\n
Note:<\/strong> The FULL OUTER JOIN<\/code> keyword returns all records from both tables. If there is no match, missing values will appear as NULL<\/code>.<\/p>\n<\/blockquote>\n\n\n\n
\n
Important:<\/strong> FULL OUTER JOIN<\/code> is not supported in SQLite<\/strong> and therefore will not work in the TechKubo playground<\/strong>. Use LEFT JOIN<\/code>, RIGHT JOIN<\/code>, or simulate with UNION<\/code> if needed.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL FULL OUTER JOIN Labs<\/h2>\n\n\n\n