Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle) RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

  • March 28, 2012 at 9:56 pm

    #1466151

    @jeff

    Did you compare the speed of this query against one where your first (Group By) From clause is a Select Distinct (sub) query?

    Nice article. It builds nicely for the reader.

    I love seeing the Except clause being introduced to the reader who, like me, cut our teeth on SQL92 and need to learn newer language features to be more productive.