SQL FULL OUTER JOIN
Completion requirements
The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records.
Note:
- FULL OUTER JOIN can potentially return very large result-sets!
- FULL OUTER JOIN and FULL JOIN are the same.
Click on SQL FULL OUTER JOIN to open the resource.