From torque-user-return-7778-apmail-db-torque-user-archive=db.apache.org@db.apache.org Mon Feb 18 18:18:31 2008 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 4074 invoked from network); 18 Feb 2008 18:18:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Feb 2008 18:18:31 -0000 Received: (qmail 43127 invoked by uid 500); 18 Feb 2008 18:18:25 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 43111 invoked by uid 500); 18 Feb 2008 18:18:25 -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 43100 invoked by uid 99); 18 Feb 2008 18:18:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Feb 2008 10:18:25 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [84.238.0.4] (HELO mail.bolignet-aarhus.dk) (84.238.0.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Feb 2008 18:17:39 +0000 Received: from [84.238.43.189] (ip-43-189.bnaa.dk [84.238.43.189]) by mail.bolignet-aarhus.dk (Bolignet-Aarhus MailService) with SMTP id YUJ93455 for ; Mon, 18 Feb 2008 19:17:55 +0100 Message-ID: <47B9CAFE.2030300@daimi.au.dk> Date: Mon, 18 Feb 2008 19:14:22 +0100 From: Martin Tilsted User-Agent: Thunderbird 1.5.0.12 (X11/20071019) MIME-Version: 1.0 To: torque-user@db.apache.org Subject: How do I control the join type of doSelectJoin? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org How do I control the join type of the doSelectJoin methods? Currently it use the "join which are not real joins, and which don't use the join keywoard". That is: The joins where it just set the fields values of the 2 relations to be equal. (The default join operation for some reason) I don't know what that kind of joins are called, so let me just call them field joins. The problem with field joins are that if you use more then one in a single query you get duplicate rows in your result, so what do I do if i have a criteria which in itself contains 2 inner joins, and I also need to use the doSelectJoin method? I can't convert it to field joins, because that will give me duplicate rows. btw: I have newer understood the reason to use field joins at all. Can anyone enlighten me on in which cases one would use a field join instead of a inner join? Martin --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org