title: MySQL Query to Update a Field with data from another Field when two Fields Match
body: <p>I need to update the content of one data field in a table with the content of another field in a table every time two separate fields, one on each table, match up. I've been trying this syntax but I just can't get it to work properly without giving me an error.</p>
  
  <pre><code>UPDATE table1
     SET field1 = table2.field1
    FROM Table1,Table2
   WHERE Table1.entry = Table2.entry
  </code></pre>