A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.

Question

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.​

Quizplus · Accepted Answer

A full outer join can be created by including an outer join operator on one side of the linking condition and a regular join operator on the other side, or by using a UNION ALL statement to combine the results of a left outer join and a right outer join. It is not necessary to include an outer join operator on both sides of the linking condition in the WHERE clause.

A Full Outer Join Can Be Created by Including an Outer