-
AND Joins
This is probably simple but I'll be darned if I can figure out how to do it...
I have a couple of tables linked by a CustomerID. The first table is of customers with the CustomerID field, the second is of items purchased by the customers. This Purchases table has a field for the ItemID and a CustomerID.
I want to create a query that will tell me which customers have purchased items with ItemID = 1 AND ItemID = 2 (and possibly Item = 3...) IE. I only want customers that have purchased BOTH or ALL the items, not just one of the items.
Any ideas?
Thanks
John F. Lund
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|