title: Part of the row to columns
body: <p>I would like to select from a table with prices and move some of the data in the rows to columns.</p>
  
  <p>Currently I have a table like this:</p>
  
  <pre><code>-----------------------------------------------
  |       Date      | Time |  PriceName | Price |
  |  2015-11-01     |   1  |    Price1  |   20  |
  |  2015-11-01     |   1  |    Price2  |   33  |
  |  2015-11-01     |   1  |    Price3  |   50  |
  -----------------------------------------------
  </code></pre>
  
  <p>And would like to select a table like this:</p>
  
  <pre><code>---------------------------------------------------------
  |       Date      | Time |    Price1  | Price2 | Price3 |
  |  2015-11-01     |   1  |      20    |   33   |   50   |
  ---------------------------------------------------------
  </code></pre>
  
  <p>I know I can select a table like this with joins, is it still a good idea to do it with joins if I have 15+ PriceNames?</p>