Hi all

I know about enginebehavior, and changes in vfp 8, but anyway I have this problem

With the next data

Table sales
Customer Purchase Amount
1 2004/01/01 150
1 2004/01/02 200
1 2004/01/15 100
2 2004/02/05 50
3 2004/02/01 180
3 2004/01/01 100

I need a select sql that returns ONE record per customer, with the max amount for each customer, and the dato of purchase of this max amount.

1 2004/01/02 200
2 2004/02/05 50
3 2004/02/01 180

In vfp 7 the next instruction works

select customer,purchase,max(amount) from sales group by customer

What can I do in VFP8?

Thanks in advance