SQL FULL JOIN

SQL FULL JOIN and FULL OUTER JOIN both are the same. The FULL JOIN used to combines the result of both LEFT and RIGHT OUTER JOIN tables, and it fill the NULL values for the missing matches.

FULL JOIN Syntax

SELECT column_name(s)
FROM table_1
FULL OUTER JOIN table_2
ON table_1.column_name = table_2.column_name
WHERE condition;

• FULL JOIN can potentially return very large datasets.
• MYSQL database does not support FULL JOINs.
• Use UNION ALL clause to join two tables in MYSQL database.

FULL OUTER JOIN

The FULL OUTER JOIN is the combination of the results of both LEFT OUTER and RIGHT OUTER JOIN, it returns all 'matched OR unmatched' rows from the tables on both sides of the join clause in SQL.

• FULL OUTER JOIN can potentially return very large result-sets