sql多表更新

--sql多表更新
update PMS_Financial_Gathering set ShouldMoney=PMS_Contract_RentScheme.Rent
from PMS_Financial_Gathering
inner join PMS_Contract_RentScheme on PMS_Financial_Gathering.RentSchemeCode=PMS_Contract_RentScheme.RentSchemeCode

转载于:https://www.cnblogs.com/howie/p/4709029.html