coming back to my earlier question but much more simplified portion of it :)
I the following table :
theTable
-----------------------
ID | int (key)
colorID | int
itemID | int
-----------------------
how do I select all itemIDs that have colorID = 1 and colorID = 2 and
colorID = 3 ... and colorID = N ?
(note: using JOIN theTable... for every colorID in question ends up with
too many JOINS in single select)
any suggestions please?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
