SEO

#1 (**permalink**) 05-11-2008, 08:41 PM

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...

#2 (**permalink**) 05-11-2008, 08:41 PM

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

#3 (**permalink**) 05-11-2008, 08:41 PM

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!

#4 (**permalink**) 05-11-2008, 08:41 PM

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....

--
Luuk

#5 (**permalink**) 05-11-2008, 08:41 PM

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
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Can someone help with my SQl statement?