update test1 t1
set itemname=t2.itemname
from test2 t2
where t2.itemcode=t1.itemcode
;
update test1
set col2=test2.col2
from test2 join test1 cat
on test2.col1=cat.col1;
update test1 t1
set itemname=t2.itemname
from test2 t2
where t2.itemcode=t1.itemcode
;
update test1
set col2=test2.col2
from test2 join test1 cat
on test2.col1=cat.col1;