Here is an example of my data:

entry_id cat_id
1 20
2 25
3 30
4 25
5 35
6 25
2 30
2 35
3 35

As you can see, entry_id's 2 and 3 both belong to cat_id 30 and 35

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.

Can someone help? Thanks...

On Sun, 11 May 2008 08:42:49 -0700, Chuck Cheeze wrote:
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

On May 11, 10:40*am, PleegWat
<pleegwat.REM... (AT) CAPS (DOT) telfort.nl.INVALID> wrote:
Perfect thanks!

Chuck Cheeze schreef:
Select DISTINCT entry_id from myTable where cat_id = '30' OR cat_id = '35'

will also work....

--
Luuk

Luuk wrote:
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 (AT) attglobal (DOT) net
==================