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