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