From torque-user-return-5604-apmail-db-torque-user-archive=db.apache.org@db.apache.org Tue Dec 07 08:11:23 2004 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 10262 invoked from network); 7 Dec 2004 08:11:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 7 Dec 2004 08:11:23 -0000 Received: (qmail 3508 invoked by uid 500); 7 Dec 2004 08:11:18 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 3493 invoked by uid 500); 7 Dec 2004 08:11:17 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: 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 3479 invoked by uid 99); 7 Dec 2004 08:11:17 -0000 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=FORGED_RCVD_HELO,FROM_ENDS_IN_NUMS,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of daniel0815@gmx.de designates 213.165.64.20 as permitted sender) Received: from pop.gmx.de (HELO mail.gmx.net) (213.165.64.20) by apache.org (qpsmtpd/0.28) with SMTP; Tue, 07 Dec 2004 00:11:15 -0800 Received: (qmail 442 invoked by uid 0); 7 Dec 2004 08:11:12 -0000 Received: from 212.185.52.170 by www67.gmx.net with HTTP; Tue, 7 Dec 2004 09:11:12 +0100 (MET) Date: Tue, 7 Dec 2004 09:11:12 +0100 (MET) From: =?ISO-8859-1?Q?=22Daniel_M=FCller=22?= To: torque-user@db.apache.org MIME-Version: 1.0 Subject: Join or Where Clause X-Priority: 3 (Normal) X-Authenticated: #4241597 Message-ID: <21646.1102407072@www67.gmx.net> X-Mailer: WWW-Mail 1.6 (Global Message Exchange) X-Flags: 0001 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Thanks for your answer. I have checked my sourcecode an I found a error. The correct statment is: SELECT blue_NumberTable.N_ID, NumberTable.N_NUMMER FROM NumberTable LEFT JOIN AdressesTable ON AdressesTable.A_N_ID=NumberTable.N_ID WHERE AdressesTable.A_N_ID IS NULL; This statement works realy fine. And the join is with equal(=) conditions. Does anyone know if its possible to create a criteria to get that statement? Thank you... Daniel -- GMX ProMail mit bestem Virenschutz http://www.gmx.net/de/go/mail +++ Empfehlung der Redaktion +++ Internet Professionell 10/04 +++ --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org