1 of 3

requirements are not clear on insert

update table1 
set t1.col1 = insull(t2.col1, t1.col2) .... 
from table1 t1 
join table2 t2 
on t2.usercode = t1.usercode