RIGHT Outer Join is same as LEFT [OUTER] JOIN keyword is use to select records that have matching values in both or among tables where returns all rows from the right (second) table specified in the ON condition and only those rows from the left(first) table where the join condition is met. It also called RIGHT Join.
Syntax
SELECT column_list FROM table1 RIGHT [OUTER] JOIN table2 ON (conditions);
Let’s examine the statement above in detail: