RIGHT JOIN

The RIGHT JOIN keyword returns all records from the right table, with the matching records in the left table. The result is NULL in the left side when there is no match.

Advertisements