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


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3