An analyst needs customers that have no matching orders. Which join directly expresses this requirement?

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

Comments — 0