DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Isaac 8/9/2011 7:24:59 AM

How to get a query of all customers that have not been shipped a product

From a recent email:

Isaac,
 
Need to run a query in SQL to find customers who have not purchased a particular product.  In this case “FNADE*”
 
I can easily query customers who have purchased a particular or range of products, but never had to query a list of customers who have not purchased a particular product…
 
Can you get me going in the right direction?
 
Thanks.

Answer:

 

Version: Unknown or N/A
Section: SQL Scripts