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

1
2
3
4
5
6
7
UPDATE
t1,t2
SET
t2.c = t1.num
WHERE
t1.ID = t2.ID