SQL Full Outer Join
This page demonstrates how a full outer join works. It does so by comparing an outer join SQL query with another query that involves a left outer join, a right outer join, and a union. As you'll see, each of these produces the same result.
Click http://www.w3resource.com/sql/joins/perform-a-full-outer-join.php link to open resource.