SQL RIGHT JOIN
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.
SQL Right Join Syntax
SELECT table1.column1, table2.column2..... FROM table1 RIGHT JOIN table2 ON table1.column_field = table2.column_field;