RIGHT OUTER Join Operations
The result set of a RIGHT OUTER
join contains all rows from both tables that meet the WHERE
clause criteria, same as an INNER
join result set.
In addition, any rows from the right table that do not have a matching row that exists in the left table will also be included in the result set.
The columns being selected from the left side table will return NULL
values.