Greetings
Please have a look at the following code and let me know if this is the
correct way to create a virtual row. Also, after having run this MySQL
returns the error that the row total_points, does not exist. Where am I
going wrong? Thank you in advance.
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
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:[EMAIL PROTECTED]
Global: www.volume4.com
Messenger
Yahoo!: v_olume4
AOL: v0lume4
MSN: [EMAIL PROTECTED]
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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
