title: MySql - Update table using select statment from same table
body: <p>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):</p>
  
  <pre><code>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;
  </code></pre>