From: Schalk Neethling (schalkvolume4.com)
Date: Tue Jul 05 2005 - 06:26:43 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Thanks to all! The AS keyword did the trick.

Philippe Poelvoorde wrote:

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

--
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Business.Solution.Developers
emotionalize.conceptualize.visualize.realize
Landlines
Tel: +27125468436
Fax: +27125468436
Web
email:schalkvolume4.com
Global: www.volume4.com
Messenger
Yahoo!: v_olume4
AOL: v0lume4
MSN: volume4_hotmail.com

We support OpenSource
Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/
 
This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]