Gowey Mike W
Mike.W.Gowey at doc.state.or.us
Thu May 19 09:12:43 CDT 2005
Here is my scenerio - I have a sales table which records the purchase of a product by a customer. It logs the product, cutomer# & Invoice#. Now I want to be able to pull from the table all customers who purchased a certain product. The part I need help with is trying to pull the customer only once. The same customer could purchase the same product more than once during the month but I only want the query to show me the customer# & product only once, not multiple times. Any advice would be greatly appreciated. Thanks, Mike Gowey MCDST, A+, LME, NET+ Team Leader - East Region Information Systems Unit