From: Kapil Tilwani <karan_pg_2@yahoo.com>
To: Randal L. Schwartz <merlyn@stonehenge.com>
To: pgsql-sql@postgresql.org
Subject: Re: [GENERAL]
Date: Wed, 30 May 2001 11:43:19 +0530
Message-ID: <000901c0e8d0$396c14c0$1300a8c0@kapil1> (raw)
References: <001f01c0e812$33a54b60$1300a8c0@kapil1>
<m13d8jh0kf.fsf@halfdome.holdit.com>
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 <merlyn@stonehenge.com>
To: Kapil Tilwani <karan_pg_2@yahoo.com>
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
> <merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/;
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: karan_pg_2@yahoo.com, merlyn@stonehenge.com
Subject: Re: [GENERAL]
In-Reply-To: <000901c0e8d0$396c14c0$1300a8c0@kapil1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox