In this article, the columns of the left table will have nulls when no matching rows exist for the row in the right table. Matching the columns of the right table will have nulls when no matching rows exist for the row in the left table
The FULL OUTER JOIN keyword is used to select all records from both tables
Syntax:
SELECT column_name(s)
FROM TABLE1
FULL OUTER JOIN TABLE2
ON TABLE1.column_name = TABLE2.column_name
Example:
SELECT Technology.*, Article.*
FROM Technologies
FULL OUTER JOIN Articles ON Technologies.ID = Articles.TechID
2020-04-21