Car ----------------------------------------- | ID | IDBrand | IDModel | Year | Price | -----------------------------------------
Characteristic -------------------- | ID | Description | --------------------
CarCharacteristics -------------------- | IDCar | IDCharac | --------------------
What I'd like to do, is to find which cars have a specific SET of characteristics. I'd like to be able to say which cars have the Characteristics 'X', 'Y' and 'Z' in ONE query.
http://lists.mysql.com/mysql/157925
Jochem
-- I don't get it immigrants don't work and steal our jobs - Loesje
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]