update shuangye_sogz set fdept= c.odept
--select *
from shuangye_sogz a,
(select op.fdept odept,b.* from shuangye_sogz b
left join op on op.opname=b.sxopname
)c
where isnull(a.fsaved,'')<>'T'
and isnull(a.qty1,0)=0 and isnull(a.qty,0)=isnull(a.qty1a,0)
and isnull(a.fdept,'')=''
and a.fsys=c.fsys
--select *
from shuangye_sogz a,
(select op.fdept odept,b.* from shuangye_sogz b
left join op on op.opname=b.sxopname
)c
where isnull(a.fsaved,'')<>'T'
and isnull(a.qty1,0)=0 and isnull(a.qty,0)=isnull(a.qty1a,0)
and isnull(a.fdept,'')=''
and a.fsys=c.fsys