update room set room .旅店名称=hotel.名称 from room , hotel where room .hotelid =hotel.hotelid
tryupdate room set room .旅店名称=hotel.名称 from room, hotel where room .hotelid =hotel.hotelid
update room set room .旅店名称=hotel.名称 from hotel --少了這個 where room .hotelid =hotel.hotelid
或者update room set room .旅店名称=hotel.名称 from room Inner Join hotel On room .hotelid =hotel.hotelid
update r set r.旅店名称=h.名称 from room r join hotel h on r.hotelid =h.hotelid
再修改下 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
少了来源,from语句没有,楼主可能一时糊涂了。。
update room set room .旅店名称=hotel.名称 from room, hotel where room .hotelid =hotel.hotelid
from room , hotel
where room .hotelid =hotel.hotelid
from hotel --少了這個
where room .hotelid =hotel.hotelid
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