title: sqlite version of vlookup
body: <p>is there a way in sqlite to do the equivalent of a vlookup? I'm trying to do something like this:
  Master table:
  ValueA | ValueB | concatValueA&amp;ValueB</p>
  
  <p>Mapping table:
  concatValueA&amp;ValueB | mapped Value</p>
  
  <p>final table:
  ValueA | ValueB | concatValueA&amp;ValueB | mapped Value</p>
  
  <p>In Excel, I would just do a vlookup.</p>
  
  <p>Is there a way to add the mapped value to a table in sqlite?</p>
  
  <p>I tried this:</p>
  
  <pre><code>UPDATE Master Set "mapped Value" = (select mapping."mapped Value" from Master left join mapping on Master.concat = mapping.concat)
  </code></pre>
  
  <p>But this fills sets the mapped Value column entirely equal to the first value from the select statement, but I would like the values to be different</p>