Re: Can't get my query right!!
From: Steve Johnson <robertoc_at_fyiowa.infi.net>
Date: 1997/08/07
Message-ID: <33E9E1F2.2206_at_fyiowa.infi.net>#1/1
WHERE a.key = b.key;
Date: 1997/08/07
Message-ID: <33E9E1F2.2206_at_fyiowa.infi.net>#1/1
I don't think that's what he wanted. In order to get only one address back from the address side you need to specify which address you want. I chose to get the max(address). You'll need to figure which you need.
SELECT a.name, a.key, b.address
FROM key a,
SELECT( key, max(address) address FROM addre group by key) b
WHERE a.key = b.key;
This results in:
NAME KEY ADDRESS
---------- ---------- ----------
John 1 New-York Michael 2 Paris Peter 3 Hong Kong
Koen Van Loo wrote:
>
> This query will give you each name, with the address in lowest alphabetical
> order
>
> select a.name, a.key, b.key, b.adresse
> from person a, adresse b
> where b.adresse = (select min(c.adresse) from adresse c where c.key =
> a.key)
> order by a.key
>
> Koen Van Loo
>
Received on Thu Aug 07 1997 - 00:00:00 CEST