MySql - Update table using select statment from same table

Question

I'm trying to update row in a table using values from a different row (and different columns) in the same table. Something along the lines of this, although my syntax produces no results: Here is the code (updated):

UPDATE table1 AS t1 INNER JOIN (SELECT field_id_46,field_id_47 FROM table1 WHERE entry_id = 36) AS t2 SET t1.field_id_60 = t2.field_id_46, t1.field_id_61 = t2.field_id_47 WHERE t1.entry_id = 45; 

Answer 1

update table as t1 inner join ( select field_id_46,field_id_47 from table where entry_id = 36) as t2 set t1.field_id_60 = t2.field_id_46,     t1.field_id_61 = t2.field_id_47 where t1.entry_id = 45 

or, simply

update table as t1, ( select field_id_46,field_id_47 from table where entry_id = 36) as t2 set t1.field_id_60 = t2.field_id_46,     t1.field_id_61 = t2.field_id_47 where t1.entry_id = 45 

Answer 2

Adding..

Same tables, with more of one registers

UPDATE table t1 INNER JOIN table t2 ON t2.entry_id = t1.entry_id SET t1.field_id_60 = t2.field_id_60,     t1.field_id_61 = t2.field_id_61