SQL- Full Join

Full Join

FULL JOIN, Whether or not there are matches in LEFT table and RIGHT table in FULL JOIN, it returns all records of both tables. If match does not happen then 'NULL' (no value) is returned.

FULL OUTER JOIN and FULL JOIN is same.

FULL JOIN has the possibility of returning very large result-set.

Full JOIN

Syntax : 

SELECT   table1.column_name,  table.2column_name
FROM table_name1  FULL JOIN table_name2 
ON   table1.common_field  = table1.common_field;