FULL Outer Join, sometimes called FULL JOIN returns all rows from the left hand table and right hand table. It places NULL where the join condition is not met. It's syntax also same as LEFT/RIGHT join except a keyword FULL.
Syntax
SELECT column_list FROM table1 FULL [OUTER] JOIN table2 ON (conditions);
Let’s examine the statement above in detail: