>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]

Reply via email to