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
(
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
扫一扫
1896
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
