Hi everyone.
I'm trying to do the following update, which someone at Macromedia gave me,
however I get a SQL error when I'm trying to use it with MySQL, any ideas on
what is wrong.
update general_users
set rolling_total = sumUsr.rollingTotal
from
(
select id,sum(jan+feb+mar+apr+may+jun+jul+aug+sep+oct+nov+dec) as
rollingTotal
from general_users
group by id
) as sumUsr
where general_users.id = sumUsr.id
Thanks.
Best Regards
>>> Andrew
www.MSOnet.co.uk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php