From: | "Kapil Tilwani" <karan_pg_2(at)yahoo(dot)com> |
---|---|
To: | "Randal L(dot) Schwartz" <merlyn(at)stonehenge(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] |
Date: | 2001-05-30 06:13:19 |
Message-ID: | 000901c0e8d0$396c14c0$1300a8c0@kapil1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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(at)stonehenge(dot)com>
To: Kapil Tilwani <karan_pg_2(at)yahoo(dot)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(at)stonehenge(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Solianic | 2001-05-30 08:43:00 | Current database name |
Previous Message | Karen Ellrick | 2001-05-30 04:48:55 | RE: Problems with new data location |
From | Date | Subject | |
---|---|---|---|
Next Message | Muhammed Yazici | 2001-05-30 07:23:56 | query on two databases .. |
Previous Message | Tom Lane | 2001-05-30 04:21:38 | Re: Shortcut? |