Right Outer Join
The right outer join returns all rows from the right hand table specified in the ON condition and only those rows from the other table where the inner join condition is true.
The right outer join is absolute opposite of left outer join.
See this example:
Let's take a table "EMPLOYEES" having the following data.
Create another table "DEPARTMENT" having the following data.
Execute the following query: