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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
