Hi all, I have a list of values I get from my application and I want to generate a record set based on this list (for an INSERT INTO ... SELECT).
Today I have sth like: SELECT 54, item.item_id, mdv.valueInt FROM item i, metadata_value mdv WHERE mdv.item_id = 20202 AND mdv.field_id = 54 AND i.item_id IN (20203,20204,20205,20206,20223,20207,20208); Is it possible not to make a look-up in 'item' table ? -- Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
