pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (2+ messages)

Message-ID: <000901c0e8d0$396c14c0$1300a8c0@kapil1>
Permalink:  ../000901c0e8d0$396c14c0$1300a8c0@kapil1/
Also on:    postgresql.org/message-id/000901c0e8d0$396c14c0$1300a8c0@kapil1

 · 

reply

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