Thanks, I ended up using that, and then realized that my need for this weird query was becase of bad DB design, and fixed that instead!
Eric -----Original Message----- From: Eric Dobbs [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 3:17 PM To: Turbine Users List Subject: Re: How do I do a correlated subquery in T2.1's Torque? On Thursday, May 9, 2002, at 12:27 PM, Eric Pugh wrote: > I wanted to be able to do this: > select * from reaction where reaction_id not in(select reaction_id from > well) > > How do you do a not in() with a select statement vesus just a bunch of > values? > > I'm guessing the Criteria.CUSTOM would work, but is there a better way? I think Criteria.CUSTOM is your only option in this case. -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]>
