|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Creating virtual rows question
From: Philippe Poelvoorde (philippe
costrading.co.uk)
Date: Tue Jul 05 2005 - 05:57:19 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> SELECT mem_number, first_name, last_name, joining_points + emc + sapmc +
> starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw + saloty +
> safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo + csf + coc +
> ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf = total_points
ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf AS total_points
Use the AS keyword, not the equal/assignment operator
> FROM modelcup.ab_leader_board
> WHERE sex = 'Female' AND cup = 'kids' AND current_pos > 0
> ORDER BY total_points ASC
>
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]