Re: Can't get my query right!!

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

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