Thanks Eric! I am doing what the archive suggests - I am creating the subselect as Criteria.CUSTOM. But what I am wondering is if there is a way to get the subselect statement from another criteria object? The Criteria.toString() method has the exact query I need, it just has a bunch of unnecessary information in front of it.
Thanks again, Steve B. ----- Original Message ----- From: "Eric Dobbs" <[EMAIL PROTECTED]> To: "Turbine Users List" <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 7:53 AM Subject: Re: [Torque] How to nest a select statement in a query > > On Tuesday, March 26, 2002, at 11:44 AM, sbelt wrote: > > > 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%') > > > > Has anyone implemented this? Is it already there and I am just not > > seeing > > it? > > > This is covered in the mail archive here: > <http://www.mail-archive.com/turbine- > user%40jakarta.apache.org/msg03764.html> > > Hope that helps. > -Eric > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
