title: Update table with values from other table
body: <p>I have a <code>table 1</code> where I have to replace some data in a column with data from a <code>table 2</code>.</p>
  
  <pre><code>Table 1
  
  A       | B
  -----------------------------
  Test A1 | 123SOMETEXT
  Test A2 | 456OTHERTEXT
  Test A3 | 789MORETEXT
  
  
  Table 2
  
  B_old | B_new
  -----------------------------
  123   | ABC
  456   | DEF
  789   | GHI
  </code></pre>
  
  <p>Using this example I have to replace for example <code>123SOMETEXT</code> in column <code>B</code> of <code>table 1</code> with <code>ABCSOMETEXT</code> and so on. How can I do that?</p>