SQL FULL OUTER JOIN Keyword
The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records.
The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records.