Sergey and Naomi
Both of your suggestions produced a result set that included all of the records from crs1.
However with a slight change to Sergey's code I got what I needed. Thank you, both.
SELECT cost, site_name ;
FROM crs1 c1 ;
WHERE cost = (SELECT Min(cost) FROM crs1 )
>Try
>
>SELECT cost, site FROM crs1 c1 ;
> WHERE cost = (SELECT MIN(cost) FROM crs1 WHERE site = c1.site)
>
>
>>Suppose you have issued a sql-select which returns several records containing the fields COST and SITE among others. Then suppose you want to select from this result the minimum COST and its corresponding SITE. As in:
>>
>>select min(cost), site from crs1
>>
>>
>>This produces an error Group clause invalid. How should this second select be structured?
>>