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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]