Suggest an editImprove this articleRefine the answer for “What does RIGHT JOIN do?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`RIGHT JOIN` does the same as `LEFT JOIN`, only the other way around - it returns **all rows from the right table** and **only the matching rows from the left one**; if the left table has no match, `NULL` fills its place. **Key point:** the example `FROM orders RIGHT JOIN customers ON orders.customer_id = customers.id` returns every customer, even without orders, and the `orders` data for those customers comes back as `NULL`.Shown above the full answer for quick recall.Answer (EN)Image`RIGHT JOIN` does the same as `LEFT JOIN`, only the other way around - it returns **all rows from the right table** and **only the matching rows from the left one**. If the left table has no match, `NULL` fills its place. ### Example ```sql SELECT * FROM orders RIGHT JOIN customers ON orders.customer_id = customers.id; ``` Result: **every customer** ends up in it, even those without orders, but the `orders` data for those customers comes back as `NULL`.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.