title: Update multiple rows using select statement
body: <p>I have these tables and values:</p>
  
  <pre><code>Table1
  ------------------------
  ID | Value
  ------------------------
  2 | asdf
  4 | fdsa
  5 | aaaa
  
  
  Table2
  ------------------------
  ID | Value
  ------------------------
  2 | bbbb
  4 | bbbb
  5 | bbbb
  </code></pre>
  
  <p>I want to update all the values in Table2 using the values in Table1 with their respective ID's.</p>
  
  <p>Is there a way to do that with a simple SQL query?</p>