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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
