>The query as written works just fine although I'm certain there's got to be
>a more efficient way of doing the same thing. I'm relatively new to MySQL
>so I took the brute force approach.
>
>My problem is that I want to produce totals of each of the columns and can't
>figure out how to do it. Any suggestions on how I can do this?
Might I suggest a mapping table relating speed to the labels desired
and the speed ratings (int -> strings). That way it's extensible and
can easily be joined to the original query?
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]