Luuk wrote:
> Chuck Cheeze schreef:
>> On May 11, 10:40 am, PleegWat
>> <pleegwat.REM...@CAPS.telfort.nl.INVALID> wrote:
>>> On Sun, 11 May 2008 08:42:49 -0700, Chuck Cheeze wrote:
>>>> I have captured the cat_id's 30 and 35 with my script, so I need all
>>>> entry_id's that belong to BOTH cat_id 30 and 35.
>>>> I tried "Select entry_id from myTable where cat_id = '30' and cat_id =
>>>> '35' but obviously that is incorrect.
>>> SELECT a.entry_id
>>> FROM myTable a
>>> INNER JOIN myTable b
>>> ON a.entry_id = b.entry_id
>>> WHERE a.cat_id = 30
>>> AND b.cat_id = 35
>>>
>>> --
>>> Remove caps to reply
>>
>> Perfect thanks!
>
> Select DISTINCT entry_id from myTable where cat_id = '30' OR cat_id = '35'
>
> will also work....
>

Nope, that will get it if EITHER is true. He needs BOTH to be true.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================