@
update target_table as t1
set target_column=(select source_column from source_table as t2 where t2.condition=t1.condition) ;
ex) update ics5_mobile.hub_ics_tblc a
set tid = (select tid from node_tblc b where a.nid=b.nid);
@ 수정할 컬럼이 두개인 경우
set(column1,column2)=(select column1,column2 from ....)
