title: SQLITE change colum name to value from cells
body: <p>I have a simple database with two tables:</p>
  
  <p><strong>dates</strong> (<code>ID</code> - PK, <code>data</code> - text):</p>
  
  <pre><code>ID | data      
  1  | 2013-02-03    
  2  | 2012-10-06  
  3  | 2014-04-22
  </code></pre>
  
  <p>and <strong>rate</strong> (<code>ID</code> - PK, <code>dataNR</code> - FK from dates(<code>ID</code>), <code>value</code> (range 0-6), <code>userNR</code> (from other base - it's not important):</p>
  
  <pre><code>ID | value | dataNR | userNR
  1  | 3     | 1      | 1
  2  | 5     | 2      | 1
  3  | 2     | 3      | 2
  </code></pre>
  
  <p>and when I use this command:</p>
  
  <pre><code>SELECT rate.ID, rate.value, dates.data, rate.userNR
  FROM rate
  INNER JOIN date ON rate.dataNR = dates.ID
  </code></pre>
  
  <p>I believe the result would be:</p>
  
  <pre><code>ID | value | dataNR       | userNR
  1  | 3     | 2013-02-03   | 1
  2  | 5     | 2012-10-06   | 1
  3  | 2     | 2014-04-22   | 2
  </code></pre>
  
  <p>but I would like to get:</p>
  
  <pre><code>userNr | 2013-02-03 | 2012-10-06 | 2014-04-22
   1     | 3          | 5          |
   2     |            |            | 2
  </code></pre>
  
  <p>How can i get it?
  I would like to add that it will be connect with c# (component datagridView, well it maybe shows new ways to result?).</p>