List:General Discussion« Previous MessageNext Message »
From:Manuel Vacelet Date:September 26 2007 2:23pm
Subject:How to use an hardcoded list of values
View as plain text  
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
Thread
How to use an hardcoded list of valuesManuel Vacelet26 Sep
  • Re: How to use an hardcoded list of valuesBaron Schwartz26 Sep
    • Re: How to use an hardcoded list of valuesManuel Vacelet3 Oct