"Brannon King" <[EMAIL PROTECTED]> wrote:
> select qi,ri,drl,max(score) as scr from ...
Are you expecting the qi, ri, and drl values to be
the ones from the row with the maximum score? I
hate to disappoint you, but SQL (not just SQLite
but SQL in general) does not work this way. To
understand why, consider the following query:
select qi, ri, drl, max(score), min(score) from ...
What values of qi, ri, and drl would you want
this query to return?
What you have to do is:
SELECT qi, ri, drl, score
FROM ...
WHERE score=(SELECT max(score) FROM ...)
--
D. Richard Hipp <[EMAIL PROTECTED]>
