FULL (OUTER) JOIN: Selects all records that match either left or right table records.

FULL JOIN can potentially return very large datasets.

FULL JOIN and FULL OUTER JOIN are the same.

SQL FULL JOIN Syntax:

SELECT column_name(s)

FROM table1

FULL OUTER JOIN table2

ON table1.column_name = table2.column_name

WHERE condition;

Example:

Lets use the “Products” and “Orders” table to perform a FULL JOIN on the “ProductID” column.

Results:

SQL Tutorial