|
Posted by Jim on 09/28/82 11:24
In article <1124379392.558896.286470@z14g2000cwz.googlegroups.com>, Tim wrote:
> not surprisingly, it's the difficult option I'm after where I want to
> return all customers who have bought productA and productB.
>
Try something like:
select custid from table where product='ProductA' and custid in
(select custid from table where product='ProductB') order by custid
Can't promise it will work but a few tests of the results should prove
it one way or the other.
Jim
--
Find me at http://www.ursaMinorBeta.co.uk
"There's no 'I' in team, but there is a 'me' if you jumble
the letters up a bit." - Dr. House.
Navigation:
[Reply to this message]
|