DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=from:organization:to:subject:date:user-agent:cc:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id;
	b=nDQZzLm23gcUA9xFct/O6l2c53R8RrxCh7t4CTKfP8LZOI2Fkbh0+S18jXwAHAVA6QCEUDp/yczVktVTexRw1rRGOI0ufhKmOzNm9fKvIA4hACTbxwALjgnh+nPrl33k4C6C1klIRsyDLs5nDD64K2xSYJzBnR72914nIiJHBfg=
From: Bryan Emrys <bryan.emrys@gmail.com>
Organization: Andras Hill
To: "Rodrigo E. De =?utf-8?q?Le=C3=B3n?= Plicet" <rdeleonp@gmail.com>
Subject: Re: SQL dealing with subquery
Date: Wed, 16 Jan 2008 07:54:41 -0800
User-Agent: KMail/1.9.7
Cc: pgsql-sql@postgresql.org
References: <eee4647d0801151004t288b0819ocbc0cae8e0df7f24@mail.gmail.com>
	<a55915760801151240w61aa3520g548eff734190061e@mail.gmail.com>
In-Reply-To: <a55915760801151240w61aa3520g548eff734190061e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200801160754.41769.bryan.emrys@gmail.com>

Thanks. It throws off a few extra countries where there is only one treaty,=
 but those are=20
few enough that I can handle them manually.

I thought the solution was also going to give me insight into how to select=
 just the lowest=20
rate from each couple, (i.e. for each payor, who is the lowest rate payee) =
but it looks like=20
I'll have find some time to think about that later (I've also got to think =
about what to do in tie situations.).

Again, thanks.

Bryan

On Tuesday 15 January 2008 12:40:13 pm Rodrigo E. De Le=C3=B3n Plicet wrote:
> On Jan 15, 2008 1:04 PM, Bryan Emrys <bryan.emrys@gmail.com> wrote:
> > In other words, in the sample above, I only want to return:
> > 'Canada','Ireland',0
> > 'Canada','Netherlands',5
>=20
> Try (untested):
>=20
> SELECT t2.*
> FROM   (SELECT   payor
>         FROM     treaty_rates
>         WHERE    payee IN ('Netherlands', 'Ireland')
>         GROUP BY payor
>         HAVING   MIN (rate) !=3D MAX (rate)) t1
>        JOIN
>        treaty_rates t2 ON t1.payor =3D t2.payor
> WHERE  t2.payee IN ('Netherlands', 'Ireland');
>=20