< snipped >
>What value should SQL Server return for city? Within this table there will probably be more than one city for each state. VFP picks a value. I don't know of there's any reasoning to the value that's chosen nor would I want to rely on it. SQL Server (and the ANSI standard I believe) take the easy approach and just don't allow it.
>
< snipped >
Mike,
VFP will group all the records togther using the GROUP BY clause and select the value(s) not specified in the clause from the last record that is physically in the table. This can and does lead to numerous problems because some developers don't realize this.