update aa a1 set a1.desc=(select b1.desc_cn from bb b1 where b1.code=a1.code) where exists ( select 1 from bb b2 where b2.code=a1.code);
--merge into merge into AA a using BB b on(a.code = b.code) when matched then update set a.desc=b.desc_cn-- update AA a set desc=(select desc_cn from BB b where a.code = b.code)
update aa a1 set a1.desc=(select b1.desc_cn from bb b1 where b1.code=a1.code) where exists ( select 1 from bb b2 where b2.code=a1.code);
set a1.desc=(select b1.desc_cn from bb b1 where b1.code=a1.code)
where exists ( select 1 from bb b2 where b2.code=a1.code);
merge into AA a using BB b on(a.code = b.code)
when matched then update set a.desc=b.desc_cn--
update AA a set desc=(select desc_cn from BB b where a.code = b.code)
set a1.desc=(select b1.desc_cn from bb b1 where b1.code=a1.code)
where exists ( select 1 from bb b2 where b2.code=a1.code);