title: Is it possible to use Crosstab/Pivot Query in MySQL?
body: <p>I'm using MySQL. This is table i have</p>
  
  <pre><code>supplier_ID   Item_ID   Date                  Price    QTY
  1             1         2012-01-01 00:00:00   500.00   2
  1             1         2012-01-03 00:00:00   450.00   10
  2             1         2012-01-01 00:00:00   400.00   5
  3             1         2012-05-01 00:00:00   500.00   1
  </code></pre>
  
  <p>I need a select query showing a table something like this.</p>
  
  <pre><code>supplier_ID      2012-01-01   2012-01-03   2012-05-01   
  1                500.00(2)    450.00(10)   null
  2                400.00(5)    null         null
  3                null         null         500.00(1)
  </code></pre>