--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
原文：http://www.cnblogs.com/howie/p/4709029.html