title: Change a column name on select
body: <p>I have a temporary table.</p>
  
  <pre><code>col_1   col_2   col_3   col_4
  ABC     B01        10       5
  ABC     B01        77       5
  ABC     B03        30       7
  ABC     B05        50      11
  ABC     B05        88      11
  DEF     B05        50      50
  DEF     B05        88      50
  DEF     B06        66      50
  A01     B02        20       0 
  A01     B04        40       0
  A02     B02        99       0
  </code></pre>
  
  <p>and this helper table:</p>
  
  <pre><code>ID1     ID2
  ABC     A01
  DEF     A02
  </code></pre>
  
  <p>What I'd like to do. If there are values in col_1 in temporary table that matches ID2 in helper table, the values are changed to ID1 in helper table. How to do this on a <code>select</code> ?</p>
  
  <p>So, when I do a select (<code>SELECT * FROM temporary</code>). This is the result:</p>
  
  <pre><code>col_1   col_2   col_3   col_4
  ABC     B01        10       5
  ABC     B01        77       5
  ABC     B03        30       7
  ABC     B05        50      11
  ABC     B05        88      11
  DEF     B05        50      50
  DEF     B05        88      50
  DEF     B06        66      50
  ABC     B02        20       0 
  ABC     B04        40       0
  DEF     B02        99       0
  </code></pre>
  
  <p>Is it possible to do that? Thanks for your help</p>
  
  <p><strong>nb:</strong></p>
  
  <p>There are a lot of values in helper table. Not just two rows. </p>