RIGHT OUTER JOIN Work
Let's suppose you have two tables 1st one LEFT_Table and 2nd one RIGHT_Table then a RIGHT OUTER JOIN returns all rows in the RIGHT Table that do not exist in the LEFT_Table in the result.
Read The Full Tutorial on SQL
Query Look Like
SELECT *
FROM LEFT_Table
RIGHT [OUTER] JOIN RIGHT_Table
ON LEFT_Table.column_name = RIGHT_Table.column_name;