List:General Discussion« Previous MessageNext Message »
From:Mike Martin Date:January 11 2006 7:42pm
Subject:Help crafting an SELECT
View as plain text  
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
1    Mustang
2    Apple
3    Rock
4    Beetle

tags:
tagid  picid    tag
1        1         Car
2        1         Red
3        2         Red
4        3         Quartz
5        4         Car
6        2         Food
7        1         1979

I'm trying to craft a query which will join the tables by the picid
column and return the entries which match multiple "tags". For
instance I want to query for items that are both "red" and "car" (to
get the records: Mustang and Beetle in this case).

I assume I should start with something like:

SELECT * FROM pics JOIN tags ON pics.picid=tags.tagid WHERE  .....

and that's where I get stuck. tag="red" AND tag="car" isn't right and
neighter is tag="red" OR tag="car".

I think this should be simple ... but I'm too new to SQL. I've messed
around with GROUPs, UNIONs, etc. but I'm just out of my league. Can
someone help, or point me to a good tutorial/explanation that would
help?

Thanks!

MikeMartin
Thread
Help crafting an SELECTMike Martin11 Jan
  • Re: Help crafting an SELECTSGreen11 Jan
  • Re: Help crafting an SELECTPeter Brawley11 Jan
Re: Help crafting an SELECTMike Martin11 Jan
Re: Help crafting an SELECTSGreen11 Jan