UPDATE table1
INNER
JOIN table2
ON table2.something = table1.something
SET table2.field2 = table1.user

UPDATE table1 SET field1 = field2