The Full Join results from a combination of both left and right join that contains all the records from both tables. It fetches rows when there are matching rows in any one of the tables. This means it returns all the rows from the left-hand side table and all the rows from the right-hand side tables. If a match is not found, it puts NULL value. It is also known as FULL OUTER JOIN.
The following visual representation explains it more clearly:
SQL Interview Questions and Answers
The following syntax illustrates the FULL JOIN:
SELECT * FROM table1
FULL OUTER JOIN table2
ON join_condition;