This website uses cookies to ensure you get the best experience.
Learn more.
An analyst needs customers that have no matching orders. Which join directly expresses this requirement?
Published
- customers INNER JOIN orders ON customers.id = orders.customer_id
- customers CROSS JOIN orders
- customers LEFT ANTI JOIN orders ON customers.id = orders.customer_id
- customers LEFT SEMI JOIN orders ON customers.id = orders.customer_id
Comments — 0
Sign in to comment