I would like to run a query like so:
select * from tableA where tableA_id not in (select tableA_id from tableB)
to give me the rows in tableA that are not referenced in tableB.
How would I do this using torque?
Criteria does not support subqueries so you would either need to code the sql manually and use BasePeer.executeQuery() (and retrieve the data from the Village Records) or run two queries, one to select tableA_id from tableB and another that uses the result of the first query with NOT_IN.
Scott
-- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
