update TravelApply set TravelApply.ApplyUser=swsmu_bpmdb.dbo.BPMU_USER.DspName ,
TravelApply.UserName=swsmu_bpmdb.dbo.BPMU_USER.DspName
from swsmu_bpmdb.dbo.BPMU_USER
where TravelApply.ApplyUser='' and TravelApply.ApplyAccount=swsmu_bpmdb.dbo.BPMU_USER.Account
SQL关联表修改数据
最新推荐文章于 2024-07-30 03:51:08 发布