Message-ID: <00e801be35ef$f93bbc10$61246ccf@timnt.desm.uswest.net>
Reply-To: "Tim Perdue, The Des Moines City.net" <tim@dmcity.net>
From: "Tim Perdue, The Des Moines City.net" <tim@dmcity.net>
To: <pgsql-sql@hub.org>
Subject: SELECT DISTINCT
Date: Fri, 1 Jan 1999 19:34:00 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I have been trying to do a SELECT DISTINCT from a pgsql table and am having
trouble. I've tried subselects, EXISTS, IN, etc, and have had no luck.

I want the query to select all the cities in a state, eliminating
duplicates. I also want the ZIP code (any one of that city's zip codes)
returned in the result set.

select distinct fld_city from tbl_zip_city where fld_state='IA' and
fld_country='us';

That query returns half of what I want (distinct city), but does not return
the associated zip code.

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).

Any suggestions?

Tim
The Des Moines City.net
http://desmoinesnet.com/