Right Join is used to join two tables and it return all rows from right table(table 2) and matching rows from table 1(left table). The result is NULL for unmatched rows for table 1(left table). Right Join keyword is used to apply Right Join on two tables.
Syntax for Right Join:
RIGHT JOIN tablename2
In the above syntax there is a column taken from both table on which Right join is applied and this column must be same in both tables.