From: Schalk Neethling Date: September 18 2005 11:08pm Subject: 1064 error List-Archive: http://lists.mysql.com/mysql/189239 Message-Id: <432DF37C.1070407@volume4.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Greetings What might be causing the 1064 error in the following query? SELECT mem_number, first_name, last_name, area_represented, joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge + Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpumalanga GP + Glam Slam Model Challenge + Model Man Woman + SA Look of the Year + SA Face of the Year + KZN Classic + Eastern Cape GP + Western Cape Classic + Free State Classic + North West GP + Northern Province Classic + SA Model Open + Cover Search + Champion of Champions + Northern Cape Classic + Goldfields Model GP + Limpopo Classic + SA Model Portfolio + Top Model Challenge + Gauteng Model Classic + Year of the Model AS total_points FROM modelcup.ab_leader_board All of the rows does exist in the table and all row names are correct. TYIA! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:schalk@stripped Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: volume4_@stripped We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error, please contact the sender and please delete all traces of this material from all devices.