Hi. I’m trying to write a query with a list of part numbers and I want to return customers who have ordered more than one of the individual products that are in that list. To be specific, the customer should not be included if they ordered one of each of products on that list, only two of the same exact product contained in that list. Here are the structures of my tables:
OrderDetails - there is one record for every item that has been purchased, so one or more of these per order.
As an example, I want to return a list of customerIDs and BillingPhoneNumbers for customers who purchased more than either of ProductCodes widget1, widget3, and widget5.
This is beyond my basic knowledge of SQL. Thanks for any help you can give. I’ll pay it forward.