How to use an hardcoded list of values

[Manuel Vacelet]

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