UPDATE t1 t2 SET t2 t1 num WHERE t1 ID t2 ID

UPDATE 
      t1,t2 
      
SET 
     t2.c = t1.num 
WHERE
     t1.ID = t2.ID