MySQL RIGHT JOIN Keyword

The RIGHT JOIN keyword in MySQL returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side if there is no match.

Example:

SELECT customers.customer_name, orders.order_id
FROM customers
RIGHT JOIN orders ON customers.customer_id = orders.customer_id;

The RIGHT JOIN keyword is useful for retrieving all records from one table along with matching records from another table, even if there are no matches.