On Wednesday 06 September 2006 15:20, you wrote: > the "direction" (desc/asc) order qualifier is per-sortfield and > defaults to asc, so to get what you're after you'd want: > > order by avg_score desc, sum_score desc > > or > > order by avg_score desc, sum_score > > if you're after 'asc' on "sum_score". > > > - Rick
Hmmm.. Seems like I have missed something important here. Thanks. -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]