The SQL right join returns all the values from the rows of right table. It also includes the matched values from left table but if there is no matching in both tables, it returns NULL.
Basic syntax for right join:
SELECT table1.column1, table2.column2…..
FROM table1
RIGHT JOIN table2
ON table1.column_field = table2.column_field;