RIGHT JOIN returns all records from the right table and matching records from the left table.

Basic RIGHT JOIN

SELECT orders.id, customers.name

FROM orders

RIGHT JOIN customers ON orders.customer_id = customers.id;

RIGHT JOIN Equivalent to LEFT JOIN

-- These are equivalent

SELECT * FROM A RIGHT JOIN B ON A.id = B.a_id;

SELECT * FROM B LEFT JOIN A ON B.a_id = A.id;

Find Unmatched Records

SELECT products.name

FROM order_items

RIGHT JOIN products ON order_items.product_id = products.id

WHERE order_items.id IS NULL;

When to Use RIGHT JOIN

RIGHT JOIN is less common. Most developers prefer LEFT JOIN by reordering tables.

Generate RIGHT JOIN Queries

AI2sql uses the appropriate JOIN for your needs.