这条SQL语句错在那里?
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
这是为什么?
谢谢!