use temporary table in select

"Andre Steinmetzger" <[email protected]>
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <CFF0C8E79AF583438440F1AC76CED2F705FA9879@dehbgcimtex1> 
Hallo,
 
i need a temporary table in my select. It is possible to do this with torque? The sql should look like this:
 
SELECT * FROM (VALUES 12345, 23456, 34567, ...) AS LIST (ltemplist), basetable 
WHERE basetable.artnr = templist
...
 
Thanks for your help.
Andre
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.