Insert into Table2(a,b, c, d) select a,a*c,c,5 from Table1
update t1 set t1.c2 = t2.c2 from t2 where t1.c1 = t2.c1
