Join con SUM e ordine colonne .........

[whisher]

Ciao.
Ho questa semplice query:

SELECT u.user_name, ur.user_id, ur.game_id, SUM( ur.user_score ) AS TOT
FROM user AS u
INNER JOIN user_result AS ur ON ur.user_id = u.user_id
GROUP BY u.user_name DESC

come faccio a mettere in ordine DESC
i risultati di TOT.
Un grazie in anticipo ...... spero

[nicola75ss]

SELECT u.user_name, ur.user_id, ur.game_id, SUM( ur.user_score ) AS TOT
FROM user AS u
INNER JOIN user_result AS ur ON ur.user_id = u.user_id
GROUP BY u.user_name
ORDER BY TOT DESC

[whisher]

Aehmm........



Grazie del suggerimento