From torque-user-return-4639-apmail-db-torque-user-archive=db.apache.org@db.apache.org Tue Apr 13 06:27:09 2004 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 48664 invoked from network); 13 Apr 2004 06:27:09 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 13 Apr 2004 06:27:09 -0000 Received: (qmail 33990 invoked by uid 500); 13 Apr 2004 06:26:41 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 33958 invoked by uid 500); 13 Apr 2004 06:26:40 -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 33808 invoked from network); 13 Apr 2004 06:26:40 -0000 Received: from unknown (HELO mail.lotto-berlin.de) (217.89.48.166) by daedalus.apache.org with SMTP; 13 Apr 2004 06:26:40 -0000 Reply-To: From: "Michael Burschik" To: "'Apache Torque Users List'" Subject: RE: Can I do this with Criteria? Date: Tue, 13 Apr 2004 08:26:55 +0200 Message-ID: <002c01c42120$51c26160$920115ac@iplan.dklb.de> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <014c01c41d84$cdb1d9d0$690ba8c0@int.globaltechbg.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N On Thursday, 8 April 2004, Bogdan Vatkov wrote: > Could you explain iun details what you need to select ... > because as far as I can see in your statement you will > have one and the same row doubled > t1.id = t2.id > says when row 5 from table A is row 5 from A > at the same time > "value" colunm from that row to has different values > ...that is nosense > > of course this is valid only if .id is a primary key > is that your select exactly ? > > regards, > bogdan I have a table of lottery results. Each row contains the ID of the draw, the ID of the number (e.g. first number drawn) and the "value", i.e. the actual number drawn. Thus, the ID is not the primary key of the table. What I need to do is to select a draw by checking whether it includes certain numbers. Regards Michael Burschik --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org