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.

Right Outer Join.