RE: use temporary table in select

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
>