>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 )
>
>
Don,
I think you're right, since you only need two fields: Site for Min cost. Both my and Sergey's suggestions would work if you need to pull out more fields. (I actually wrote my code based on some old code from Sergey).
If it's not broken, fix it until it is.
My Blog