>>>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!!
>>
>>If you have an index on Field2, the following code will give you all records, which have max Field2:
>>

>>select field1, field2 from Table1 where field2 in (select max(field2) from table1)

>
>I'm wondering why the message title says 'Max(field1)'? :)

Oops :( :) Ok, the code should be transversed (??) :)