[RESOLVED] A Query question on getting largest value for two fields

[khovorka]

Hello,

I need to have a single query that returns the Max value for two fields
so something like this:

SELECT Max(Y + SIZE) As MY from Table;

In other words I need to get the largest combined value of the two fields.
Each table row has a Y + a SIZE and I need to get the Row whose value
is the greatest combined number for the two fields.

Thank you.

Kim H.

[laserlight]

hmm... it seems to me that that SQL statement should work. What database management system are you using, and what is the error message?