title: Update table from another table: Difference between using inner join and update multiple tables?
body: <p>I would like to update table 1 column 'num' with the value in table2.</p>
  <p>might be really basic.. but I could not find the difference between using
  <code>inner join</code> and <code>update table x, y where xxxx</code> in this scenario.</p>
  <p>let's say I have two tables:</p>
  <pre><code>table1 
  name | num
  name1  1
  name2  2
  name3  3
  
  table2
  name | num
  name1  11
  name2  22
  name4  44
  </code></pre>
  <p>what I want is:</p>
  <p>table1:</p>
  <pre><code>name | num
  name1  11
  name2  22
  name3  3
  </code></pre>
  <p>I could achieve this by running</p>
  <p>Method1:</p>
  <pre><code>UPDATE table1, table2
  SET table1.num = table2.num
  where table1.name = table2.name
  </code></pre>
  <p>and</p>
  <p>Method2:</p>
  <pre><code>UPDATE table1
  inner join table2 on table1.name = table2.name
  SET table1.num = table2.num
  </code></pre>
  <p>I get the same result and I was wondering if I can use either one.. or is there any difference between these two queries??
  I think I need use method1 to update both table..
  but if I want to update only 1 table like in this scenario, does it matter which query I use?</p>