>Field1, Field2
>10, 4
>15, 3
>7, 9
>Select Max(field1),field2 from table1
>does not work the way I need it to be. I need the max. value in Field1 (=15), and it's corresponding field2 (=3). The above select statement will give me the correct field1, but not returning its corresponding field2. I think it returns the first record in field2 instead.
>Is there a way to achieve what I need?
>Thank you all!!
In cases like this foxpro returns filed2 value from the last record in the physical order. Anyway
SELECT filed1, field2 ;
FROM table1 ;
WHERE filed1 in ( Select Max(field1) from table1)
--sb--