db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andre Steinmetzger" <Andre.Steinmetz...@cimt-ag.de>
Subject use temporary table in select
Date Mon, 14 Apr 2008 08:47:51 GMT
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
 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message