I am trying to create the following sql:
SELECT * FROM table3
WHERE table3.colum1 IN
( SELECT table4.column1 FROM table4
WHERE table4.column3 LIKE '%find-me%')
[forgive any typos in the above example, but I hope it expresses the gist -
I am trying to nest my selects so I can get my records in a single call. I
see the .addIn() methods, but they all use java objects as parameters. Is
there a version of the .addIn which accepts a criteria object?
If I were to add this functionality myself, would you suggest using the
torque-generated extension to the BasePeer classes? I considered using the
util class that allows me to simply pass a select String, but I fear this
approach runs the risk of limiting me to a single database, true?
Has anyone implemented this? Is it already there and I am just not seeing
it?
TIA,
Steve B.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
