update u set u.FAmt=co.FPayAmt from TUseLog u left join TCard c on u.FCardID=c.FId left join TCustomer cu on c.FCustomerID=cu.FId left join TCardOrder co on co.FCustomerId=cu.FId where u.FType='2'
sqlServer 更新表字段的值为另一个表的字段值
最新推荐文章于 2024-07-19 03:25:50 发布