Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

Thu, 29 Mar 2012 06:00:00 UT

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.

SQLServerCentral.com Articles tagged Subquery

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)