Full Outer Join:

Full Outer Join returns all the rows from both the Left and Right table. If there is any matches missing from the Left table then it returns Null value for the Left side Table. .If there is any matches missing from the Right table then it returns Null value for the Right side Table.