UPDATE a table with subselect

UPDATE table1
SET value1 =
(SELECT value2 FROM table2 t2 WHERE t2.id = table1.t2_id );