How To Use FULL OUTER JOIN Keyword In SQL

In this article, we will learn how to use the FULL OUTER JOIN keyword in SQL. The FULL OUTER JOIN is also known as FULL JOIN.

The FULL OUTER JOIN keyword is used to select all records from both tables.

The columns of the left table will have nulls when no matching rows exist for the row in the right table. Similarly, The columns of the right table will have nulls when no matching rows exist for the row in the left table.

Syntax

SELECT column_name(s)
FROM TABLE_NAME1
FULL OUTER JOIN TABLE_NAME2
ON TABLE_NAME1.column_name = TABLE_NAME2.column_name;

Example

The subsequent statement would select all technologies and all articles.

SELECT Technology.*, Article.*
FROM Technology 
FULL OUTER JOIN Article ON Technology.ID = Article.TechID;

 

Also, check How To Use RIGHT JOIN Keyword In SQL