db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: use temporary table in select
Date Tue, 15 Apr 2008 08:30:07 GMT
I have looked through the Criteria methods, but I have not found anything
to produce this exact query.
Maybe you could use a Subselect instead ? This is possible in Torque 3.3
If not, you would have to compose the query manually.

    Thomas

> 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
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message