FULL OUTER JOIN Keyword In SQL Server

FULL OUTER JOIN Keyword In SQL Server

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