A customers table has one row per customer. An orders table may have no rows for a customer. Which join preserves every customer while attaching matching orders?

Published
  1. customers INNER JOIN orders ON customers.id = orders.customer_id
  2. customers RIGHT JOIN orders ON customers.id = orders.customer_id
  3. customers CROSS JOIN orders
  4. customers LEFT JOIN orders ON customers.id = orders.customer_id

Comments — 0