这条SQL语句错在那里？

[swanmarx]

update
jf_fee as a,
wy_room as b,
jf_calculaterecord as c,
wy_building as d

set a.paymethod='托收数据'
where
a.id=b.id
and b.buildingareaid='0707101202_1000000000000000038'
and b.buildingid='0707104859_1000000000000000228'
and d.buildingid='0707104859_1000000000000000228'
and a.is_arrears!='欠费已转'
and a.calserial=c.calserial
and c.calserial='0707013858_1000000000000002332'
and (a.status='未缴费' or latefeestatus='未缴费' or latefeestatus='')
and b.id='0707113543_1000000000000001580'

在MYSQL数据库下执行时，有的机器可以，有的不行
错误信息：
ERROR 1064: You have an error in your SQL syntax near 'as a,
wy_room as b,
jf_calculaterecord as c,
wy_building as d
set a.payme' at line 2

这是为什么？
谢谢！

[mtou]

要更改数据的列的名称,能用别名吗?

[aku0708]

up

[swanmarx]

其实没有错！

[huangry]

up

[WnEunfn]

SQL没有错，可能是MySQL的问题……

[spiritsl]

不支持别名
不支持update多表。