FULL OUTER JOIN

A FULL OUTER JOIN combines the results of LEFT JOIN and RIGHT JOIN.

It returns all rows from both tables, filling in NULLs where there is no match.

Syntax

SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.column = table2.column;