1. 首页
  2. 问题
  3. sql查询更新INNER JOINED表
admin

sql查询更新INNER JOINED表

sql

我在我的2个表格（GuestInfo和Reservation）中使用INNER JOIN

select  RoomNo, DateStart, DateEnd, GuestFName, GuestMName, GuestLName
from GuestInfo inner join Reservation
on GuestInfo.GuestID = Reservation.GuestID

现在，我想更新该内联接表

update (select  RoomNo, DateStart, DateEnd, GuestFName, GuestMName, GuestLName
from GuestInfo inner join Reservation
on GuestInfo.GuestID = Reservation.GuestID) set EndDate = '1/20/2014'
where GuestFName = 'JAKE'

但是此查询是错误的。这可能吗？


阅读 175

收藏
2021-06-07

共1个答案

admin

您应该能够根据数据库使用与此类似的东西。

SQL Server：

update r
set r.DateEnd = '2014-01-20' 
from Reservation r
inner join GuestInfo g
    on g.GuestID = r.GuestID 
where g.GuestFName = 'JAKE'

MySQL：

update Reservation r
inner join GuestInfo g
    on g.GuestID = r.GuestID 
set r.DateEnd = '2014-01-20' 
where g.GuestFName = 'JAKE'
2021-06-07