Sergey --
The thought of MIN or MAX on non-numeric fields had never occurred to me. What do you get as a result -- the first(or last) value based on same criteria as used when ordering by that field?
Jim
>If you don't care about value of the second field, use MIN() or MAX().
select serv, MIN(desc1) AS desc1 ;
> from dtparat ;
> group by serv
>* or
>select serv, MAX(desc1) AS desc1 ;
> from dtparat ;
> group by serv
>
>
>>
>>I'm trying to clean up a GROUP BY query so that it will work with VFP9 (using ENGINEBEHAVIOR 90). I need to group by a single field (SERV), while including another as a descriptor (DESC1). The second field may have slightly different spelling across similar records and I don't really care which is included in the result.
>>
><snip>
Jim Nelson
Newbury Park, CA