Limiting Results by another Column

[repoman07]

Hello All-

I am running queries off of very large data sets (100,000's rows). I want to limit my results to a specific category. I have 3 "Product Types" (HW, SW, and Services) that "Customers" can purchase. I'm trying to analyze the "Customers" that have purchased "Services" and thier related HW or SW purchases. I can filter on Product Type=Services, but that eliminates all HW and SW purchases.

What I want to do, is limit my results to all "Customers" that have purchased Product Type=Services and return all the "HW" and "SW" purchases that those customer may have purchased as well.

How do I set my criteria for these results?

Thanks for the help!!!

Bill

 

[GumbyD]

You could do this with two queries: First use the query you have to get a list of all the customers who have purchased services. Then in a new query bring in the results of the first query join it to the table with all of the customer purchases. Then you can see all the services or products purchased by just those customers.

GumbyD

 

[repoman07]

Thanks GumbyD!!! That's very good advice!!! Have a nice day Bill