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