db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graham Leggett <minf...@sharp.fm>
Subject Structuring a query with torque - excluding rows from a join
Date Mon, 01 Dec 2003 16:16:17 GMT
Hi all,

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?

Regards,
Graham
--


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message