Query: X And Y

[ps32208]

Hi I am creating query where by I want to pull out all customers who have option 1 and option 2 products. How do I achieve this? Any help is greatly appreciated. I have tried doing "option 1" And "option 2" but it returns no records when I know there are examples of what I am trying to find.


Thanks
P

 

[SkipVought]

hi,

First off, you never posted the query that is not working for you. please do that.

"...I want to pull out all customers who have option 1 and option 2 products..."

Do you want to return...

customers that have BOTH option 1 and option 2 products or

customers that have EITHER option 1 and option 2 products???

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[ps32208]

Hi,

Sorry it was both.

But not to worry I have solved the problem.

Thanks for your time anyway.

 

[SkipVought]

As you know, many other members browse these threads, looking for tips and solutions.

It is always helpful when you explain exactly what you did to solve your problem, in order to be of help to others.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}