您应该能够根据数据库使用与此类似的东西。
SQL Server：
update rset r.DateEnd = '2014-01-20' from Reservation rinner join GuestInfo g on g.GuestID = r.GuestID where g.GuestFName = 'JAKE'
MySQL：
update Reservation rinner join GuestInfo g on g.GuestID = r.GuestID set r.DateEnd = '2014-01-20' where g.GuestFName = 'JAKE'
