update 中条件有多个表怎么办?

[civilman]

我有2个表,我使用下面的语句更新怎么会报错:
update room set room .旅店名称=hotel.名称 where room .hotelid =hotel.hotelid

[QQMagicer]

update room set room .旅店名称=hotel.名称
from room , hotel
where room .hotelid =hotel.hotelid

[paoluo]

try

update room set room .旅店名称=hotel.名称 from room, hotel where room .hotelid =hotel.hotelid

[xmlquit]

update room set room .旅店名称=hotel.名称
from hotel --少了這個
where room .hotelid =hotel.hotelid

[paoluo]

或者

update room set room .旅店名称=hotel.名称 from room Inner Join hotel On room .hotelid =hotel.hotelid

[mengmou]

update r set r.旅店名称=h.名称 from room r join hotel h on r.hotelid =h.hotelid

[paoluo]

再修改下


update room set room.旅店名称=hotel.名称 from room, hotel where room.hotelid =hotel.hotelid

或者

update room set room.旅店名称=hotel.名称 from room Inner Join hotel On room.hotelid =hotel.hotelid

[franklau_21cn]

少了来源，from语句没有，楼主可能一时糊涂了。。

[数字化从业者老高]

update room set room .旅店名称=hotel.名称 from room, hotel where room .hotelid =hotel.hotelid