SQL RIGHT OUTER JOIN
An OUTER JOIN is used to return results by combining rows from two or more tables. The SQL RIGHT OUTER JOIN returns all rows from the right table, whether or not they have matching rows from the left table.
SYNTAX OF RIGHT JOIN
SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name = table_name2.column_name;