RIGHT JOIN

Database Dictionary -> RIGHT JOIN

RIGHT JOIN

The RIGHT OUTER JOIN known also as RIGHT JOIN returns all rows from the right table in the RIGHT OUTER JOIN clause, not matter if the joined columns match. If a row in the right table (second table) doesn’t match a row in the left table (first table), the returned value for the first table is set to NULL.

SQL Tutorial