title: UPDATE based on if value exist in another table
body: <p>I have two tables</p>
  
  <p>Table A</p>
  
  <pre><code>Number
  111       
  222       
  333       
  444       
  </code></pre>
  
  <p>Table B</p>
  
  <pre><code>Number    Another
  111       AAA
  222       BBB
  666       CCC
  777       DDD
  </code></pre>
  
  <p>What I am would like to do, is apply an UPDATE statement conditional on whether the "Number" value in Table B exist in Table A. So the table would end up looking something like this.</p>
  
  <pre><code>Number    Another
  111       ZZZ
  222       ZZZ
  666       CCC
  777       DDD
  </code></pre>
  
  <p>I know I need to use an UPDATE query and probably some kind of JOIN, but I am not sure on the syntax.</p>
  
  <p>Any help greatly appreciated.</p>