FULL OUTER JOIN | SQL
In SQL, FULL OUTER JOIN is used for the combination of the results of both LEFT OUTER JOIN and RIGHT OUTER JOIN then returns all 'matched or unmatched' rows from the tables on both sides of the join clause in SQL.
Full Outer Join Query Syntex in SQL
SELECT column_name(s)
FROM left_table
FULL OUTER JOIN right_table
ON left_table.column_name = right_table.column_name
WHERE condition;
Important Points
- SELECT, FROM, FULL OUTER JOIN, ON & WHERE are SQL query syntax.
- Two tables are used in this query left_table TABLE-1 and right_table TABLE-2.
- column_name(s) belong to specific tables.
- FULL OUTER JOIN can return very large result sets.
- FULL OUTER JOIN and FULL JOIN are the same in SQL.