From: "Ian C. Sellers" <"ian"@mystical.net (temporarily out-of-order)>
Subject: Re: Can't get my query right!!
Date: 1997/08/08
Message-ID: <5sff0r$7vp@news-1.boco.co.gov>#1/1
References: <33E8C278.13703AF7@crim.ca> <33E9EEE3.B096B1A9@columbia.edu> <5sfeqq$7vp@news-1.boco.co.gov>
X-Priority: 3 (Normal)
Organization: Boulder County GIS
Reply-To: icslu@boco.co.gov
Newsgroups: comp.databases.oracle.tools



Oops!  Missed a hard return.

SELECT DISTINCT NAME.NAME, NAME.KEY, MIN(ADDRESS.ADDRESS)
FROM                      NAME, ADDRESS
WHERE                   NAME.KEY = ADDRESS.KEY;

enjoy.
-Ian