RIGHT JOIN

RIGHT JOIN — Returns all rows from the right table and the matched rows from the left table.

RIGHT JOIN

SELECT
FROM table1
RIGHT JOIN table2
ON table1.column_name = table2.column_name;