View Single Post

  #1 (permalink)  
Old 05-11-2008
Chuck Cheeze
 
Posts: n/a
Default Can someone help with my SQl statement?

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...
Reply With Quote