批量更新数据

update domsetaccountbody set dfid = domsetaccount.dsid from domsetaccount
where domsetaccount.cdscode = substring(DomSetAccountBody.cRemark, 4, len(DomSetAccountBody.cRemark)) and
domsetaccountbody.dsid in
(
select DomSetAccount.dsid from DomSetAccount where DomSetAccount.isback = 1
)