FULL JOIN

FULL JOIN — Returns rows when there is a match in one of the tables. It combines the results of both LEFT JOIN and RIGHT JOIN.

FULL JOIN

SELECT *
FROM table1
FULL JOIN table2
ON table1.column_name = table2.column_name;