SQL FULL JOIN
The SQL full join is the result of combination of both left and right outer join and the join tables have all the records from both tables. It puts NULL on the place of matches not found.SQL full outer join and SQL join are same. generally it is known as SQL FULL JOIN.
SQL Full Join Syntax
SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;