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: <5sfeqq$7vp@news-1.boco.co.gov>#1/1 References: <33E8C278.13703AF7@crim.ca> <33E9EEE3.B096B1A9@columbia.edu> X-Priority: 3 (Normal) Organization: Boulder County GIS Reply-To: icslu@boco.co.gov Newsgroups: comp.databases.oracle.tools Chris,

I don't think this meets the intent of the query.  David wanted to match each name with one of its addresses, while this will match each name with all of its addresses.

chris wrote:

   Try this:

SELECT    NAME.NAME, NAME.KEY, ADDRESS.ADDRESS
FROM       NAME, ADDRESS
WHERE     NAME.KEY = ADDRESS.KEY;

good luck.

Christopher Suh

I think this would be the simplist way to write it.  MIN could be replaced by some other group function, built-in or created, depending on which address you wish to select.

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

enjoy.
-Ian