title: SQL query to merge rows
body: <p>I have an excel spreadsheet which pulls records from SQL. I want to combine the records and sum the qty field of matching records. I tried adding a select(sum) and group by command to my existing query but I didn't get very far as I have no real SQL experience. My table looks like this:</p>
  
  <pre><code>date.     |      tax description | tax%| tax 
  1/02/2013          PST              5 %  2
  1/02/2013          GST              7%   3
  2/02/2013          PST             5%   2
  </code></pre>
  
  <p>and I want it to look like this:</p>
  
  <pre><code>date.     |       tax%           | tax(PST) | tax(GST)
  1/02/2013       (5 +7 = )12%      2              3
  
  2/02/2013             5%           2             0
  </code></pre>
  
  <p>can anyone help me what should the query look like?</p>
  
  <p>I am really new to sql and i tried doing group by tax description and date but I am unbale to understand how to merge them at the end</p>