复杂sql 更新

update t1  set t1.delstatus=0 from orders t1 inner join
(
select t2.*,s.StrNumber from  DataMigr_HQV4..trsDTPOMaster t2
inner join DataMigr_HQV4..adDTStore s on s.ID=t2.StoreID
) t2
on t1.storenum collate Chinese_PRC_CI_AS=t2.StrNumber
  and t1.number collate Chinese_PRC_CI_AS=t2.PONO
and t1.busidate=t2.PODate