Hi,
Subqueries are implemented and documented in the svn version(3.2.1-dev),
but not in Torque 3.2.0.
Either build Torque from svn or, if you want to use Torque 3.2.0. you can
code the subquery as custom criteria (see
http://db.apache.org/torque/releases/torque-3.2
/runtime/reference/read-from-db.html#Using_the_CUSTOM_modifier_to_use_custom_SQL)
(you can also build the subquery via another Criteria and its
toString()-method if you do not want to hand-code it).
Thomas
"Pfiester, Jan" <[EMAIL PROTECTED]> schrieb am 16.10.2006
17:40:05:
> Hi everyone,
>
> I ran into problems to setup the following query using criteria:
>
> SELECT DISTINCT * FROM kundenadresse
> WHERE kundenadress_id NOT IN(
> SELECT kundenadress_id FROM adressenreferenz
> );
>
> Could someone please give me some help to come up with a proper solution?
> Hints for further reading on this topic would also be very much
appreciated!
>
> Many thanks in advance,
> Jan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
