title: mysql join 2 table to select one row fields with multiple rows
body: <p>I need to join two table as follows - table 2 'value' on table 1 'price_1', 'price_2' &amp; 'price_3' so I can output price label instead of the price value. Not sure how approach this in codeigniter. Do I use join the then nested select?:</p>
  
  <p><strong>table 1</strong></p>
  
  <pre><code>id  |   price_1   |   price_2  |  price_3
  1   |     6       |      5     |     4
  </code></pre>
  
  <p><strong>Table 2</strong></p>
  
  <pre><code> id | label | value
  1   |  £6.50 | 6
  2   |  £2.50 | 5
  3   |  £4.00 | 4
  </code></pre>
  
  <p>Any pointers would be appreciated.</p>