Received: from smtp010.mail.yahoo.com (smtp010.mail.yahoo.com [216.136.173.30]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5U6DOa24876 for ; Sat, 30 Jun 2001 02:13:24 -0400 (EDT) (envelope-from karan_pg_2@yahoo.com) Received: from dialpool-210-214-41-151.maa.sify.net (HELO kapil1) (210.214.41.151) by smtp.mail.vip.sc5.yahoo.com with SMTP; 30 Jun 2001 06:13:22 -0000 X-Apparently-From: Message-ID: <000901c0e8d0$396c14c0$1300a8c0@kapil1> From: "Kapil Tilwani" To: "Randal L. Schwartz" , References: <001f01c0e812$33a54b60$1300a8c0@kapil1> Subject: Re: [GENERAL] Date: Wed, 30 May 2001 11:43:19 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200106/475 X-Sequence-Number: 3778 A real (equi) join is not possible because the query what I posted on the mailing list was WRONG... sheesh... sorry what i meant was : select * from purchasemaster where transactionid NOT in (select transactionid from itemmaster where itempriority = 2) Thanx, ----- Original Message ----- From: Randal L. Schwartz To: Kapil Tilwani Sent: Friday, June 29, 2001 7:04 PM Subject: Re: [GENERAL] > why not just do a real join? > > select a, b, c, from from purchasemaster, itemmaster > where purchasemaster.transactionid = itemmaster.transactionid > and itemmaster.itempriority = 2 > > don't fight SQL. :) > > -- > Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 > > Perl/Unix/security consulting, Technical writing, Comedy, etc. etc. > See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training! > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com