RIGHT JOIN (or RIGHT OUTER JOIN): Returns all rows from the right table and?

matched rows from the left table. If there’s no match, NULL is returned for the left

table.

• Use case: When you want all records from the right table.