Thanks - the MIN and GROUP BY did the trick. Here's what I did in the end:
select fld_city, min (fld_zip) from tbl_zip_city where fld_state = 'IA'
group by fld_city;
And now I'm good to go!
Tim
The Des Moines City.net
http://desmoinesnet.com/
-----Original Message-----
From: Peter Garner <peter_garner@yahoo.com>
To: pgsql-sql@hub.org <pgsql-sql@hub.org>
Date: Friday, January 01, 1999 8:46 PM
Subject: Re: [SQL] SELECT DISTINCT
>Hi Tim,
>
>> select distinct fld_city, fld_zip from tbl_zip_city where
>fld_state='IA' and
>> fld_country='us';
>>
>> That query does not return distinct cities any more. It returns all
>cities
>> (because each city can have several zip codes).
>>
>
>Yes, that is what it is supposed to do, heheheh. Try something like :
>
>select city, min (zip_code)
>from tbl_zip_city
>group by city
>having fld_state = 'IA'
>
>Basically since you have multiple zip codes and want only one per city
>you have to tell the sql engine which zip code to pick. It won't just
>select one at random. I hope this helps! :-)
>==
>
>Peace,
>
>Peter
>
>_________________________________________________________
>DO YOU YAHOO!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
