This website uses cookies to ensure you get the best experience.
Learn more.
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
- customers INNER JOIN orders ON customers.id = orders.customer_id
- customers RIGHT JOIN orders ON customers.id = orders.customer_id
- customers CROSS JOIN orders
- customers LEFT JOIN orders ON customers.id = orders.customer_id
Comments — 0
Sign in to comment