db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vandahl ...@apache.org>
Subject Re: Left Join on multiple clauses
Date Mon, 22 Oct 2007 17:23:58 GMT
Jonathan Halland wrote:
> My final aim for the query is to get the ones that do not join. I can used a
> nested "not in" subselect, but it is just incredibly slow when doing the
> select. Any suggestions on how else to do it? 

Like this:

   criteria.addJoin(AccountPeer.ACCOUNT_ID,
	CampaignHandledObjectsPeer.OBJECT_ID, Criteria.LEFT_JOIN);

   criteria.add(CampaignHandledObjectsPeer.OBJECT_ID, 0,
	Criteria.IS_NULL);


Bye, Thomas.

---------------------------------------------------------------------
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