FULL JOIN

FULL JOIN :
SQL returns all rows from both tables, combining matched rows and filling unmatched rows with NULL values. It is basically the combination of LEFT JOIN and RIGHT JOIN.

SYNTAX :

SELECT columns
FROM table1
FULL JOIN table2
ON table1.column = table2.column;