[EMAIL PROTECTED] wrote on 01/11/2006 03:53:26 PM:
> On 1/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> > [EMAIL PROTECTED] wrote on 01/11/2006 02:42:27 PM:
> >
> >
> > > Hi List!
> > >
> > > Please forgive me if I'm asking the wrong list (and please guide me
to
> > > the righ
On 1/11/06, Gordon Bruce <[EMAIL PROTECTED]> wrote:
> I assume you are looking for both red and car.
> You can not use IN because that is implicitly an IN.
> You hae to join the tags table to itself using 2 different aliasis.
> {If you required 3 things then you would join it 3 times etc..}
>
> SEL
Mike,
You're in the right place. If I understand your requirement correctly,
you want entries which...
match on id,
match a selection from ('Mustang' or 'Beetle'),
match multiple values in tags (eg 'red' and 'car').
Here's one solution:
SELECT p.photo, t.tag
FROM pics p
INNER JOIN tags c USI
[EMAIL PROTECTED] wrote on 01/11/2006 02:42:27 PM:
> Hi List!
>
> Please forgive me if I'm asking the wrong list (and please guide me to
> the right place).
>
> I have two tables (simplified for this example) "pics" and "tags" like
so:
>
> pics:
> picid photo
> 1Mustang
> 2Apple
> 3
Hi List!
Please forgive me if I'm asking the wrong list (and please guide me to
the right place).
I have two tables (simplified for this example) "pics" and "tags" like so:
pics:
picid photo
1Mustang
2Apple
3Rock
4Beetle
tags:
tagid picidtag
11 Car
2
