Right Outer Join

This logical operator returns all the records from right hand side table and similar records from left hand side table.

Example

Lets have data as below :-

Now use Right Outer Join (we can use as Right Join also) and have a look at returned result set as below :-

Facebook page