title: How to display one rows from the two rows
body: <p>I have <code>type</code> column in my table, <code>type</code> column value is <code>HOT</code> and<code>NOT</code>.  from that i want to display <code>HOT</code> and <code>NOT</code> values of the column in to one line.</p>
  
  <p>Example</p>
  
  <p>Table1</p>
  
  <pre><code>Period ID Total
  
  11/2011 101 250
  12/2011 102 350
  11/2011 103 450
  ....
  </code></pre>
  
  <p>Table2</p>
  
  <pre><code>Period ID Type Value
  
  11/2011 101 NOT 500
  11/2011 101 HOT 200
  12/2011 102 NOT 300
  12/2011 102 HOT 200
  ....
  </code></pre>
  
  <p>I want to display type (<code>Hot</code> and <code>Not</code>) in to one line</p>
  
  <p>Expected Output</p>
  
  <pre><code>Period ID NOT HOT Total
  
  11/2011 101 500 200 250
  12/2011 102 300 200 350
  11/2011 103 300 400 450
  ....
  </code></pre>
  
  <p>How to make a query.</p>