In some databases RIGHT JOIN is called RIGHT OUTER JOIN. The RIGHT JOIN keyword is bassically use for the Returning to the all rows from the right table (table_name2), even if there are no matches in the left table (table_name1).
Syntax : SELECT column_name(e)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name=table_name2.column_name
