>No, I meant AGGREGATE functions, not functions like TOP. 'First' on some SQL servers means 'first row from group', last - 'last row from group'. Thus you can use VFP-style grouping, but because requirement to put all fields into aggregate function use 'first' or 'last' for all fields that are not really calculated.
>
OIC.
I don't know that it does.
What's the syntax for that?
Insanity: Doing the same thing over and over and expecting different results.