update cas set cas.DocumentHeaderIdOfTransferredForForm = apply.Id from dbo.CaseTransfer cas join dbo.DocumentHeader noti on noti.Id = cas.DocumentHeaderId JOIN dbo.DocumentHeader apply ON noti.CheckMissionId=apply.CheckMissionId
update cas set cas.DocumentHeaderIdOfTransferredForForm = apply.Id from dbo.CaseTransfer cas join dbo.DocumentHeader noti on noti.Id = cas.DocumentHeaderId JOIN dbo.DocumentHeader apply ON noti.CheckMissionId=apply.CheckMissionId
转载于:https://www.cnblogs.com/taoshengyujiu/p/9177982.html