Hi, > how do I select all itemIDs that have colorID = 1 and colorID = 2 and > colorID = 3 ... and colorID = N ? > Try this
SELECT itemID FROM theTable WHERE colorID IN (1,2,3,...,N); G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]