The Right join is used to retrieve all rows from the right-hand table and only those rows from the other table that fulfilled the join condition. It returns all the rows from the right-hand side table even though there are no matches in the left-hand side table. If it finds unmatched records from the left side table, it returns a Null value. This join is also known as Right Outer Join.
The below visual representation explain this join more clearly:
SQL Interview Questions and Answers
The following syntax illustrates the RIGHT JOIN:
SELECT colum_lists
FROM table1
RIGHT JOIN table2
ON join_condition;