A warehouse query must retain customers with no orders and show null order columns. Customers is the left table. Which join fits?

Published
  1. LEFT JOIN Orders on customer key
  2. LEFT ANTI JOIN as a complete substitute
  3. CROSS JOIN Orders
  4. INNER JOIN Orders

Comments — 0