Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 68727 invoked from network); 22 Oct 2007 17:24:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 22 Oct 2007 17:24:26 -0000 Received: (qmail 74451 invoked by uid 500); 22 Oct 2007 17:24:14 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 74429 invoked by uid 500); 22 Oct 2007 17:24:14 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 74418 invoked by uid 99); 22 Oct 2007 17:24:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Oct 2007 10:24:13 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [62.13.136.39] (HELO outmail136039.authsmtp.net) (62.13.136.39) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Oct 2007 17:24:15 +0000 Received: from outmail128178.authsmtp.net (outmail128178.authsmtp.net [62.13.128.178]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l9MHNsUv094849 for ; Mon, 22 Oct 2007 18:23:54 +0100 (BST) Received: from [192.168.178.2] (p57AB3B2A.dip0.t-ipconnect.de [87.171.59.42]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l9MHNr3V012779 for ; Mon, 22 Oct 2007 18:23:53 +0100 (BST) Message-ID: <471CDCAE.3010508@apache.org> Date: Mon, 22 Oct 2007 19:23:58 +0200 From: Thomas Vandahl User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: Left Join on multiple clauses References: <000d01c81176$a7e1b7e0$f7a527a0$@com> <001401c8118e$e2ed9b70$a8c8d250$@com> In-Reply-To: <001401c8118e$e2ed9b70$a8c8d250$@com> X-Enigmail-Version: 0.95.3 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Server-Quench: 904c532a-80c3-11dc-b86a-001185d377ca X-AuthRoute: OCdyaAgQClZJUiwT EioPDCIGTh8qMAFL GwYeIE5HO1cTfQhb dE9CJ1FTPRsbX15P AWQUJAcQT19xWWRl agJbbwZXZ04AVwJ0 UU9IXFdbCgFqHh4E GR5QDhAPD3sEexhw ZERlWXkVXUR+dAh0 QkoHEG4ENHpoaDMc TUFZI1BJIgtMLwJF alF+XHZZYmIANSsu JQJhdxQ8MykXCiNU REkKKxoXXEIXHyY4 SlgJGTwyBkAeL2Qg X-Authentic-SMTP: 61633138303539.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Checked: Checked by ClamAV on apache.org 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