title: How to total SQL results
body: <p>How do I get my results to total into one record instead of multiple instances of  item_id. instead I need the total qty invoiced for each item. </p>
  
  <p>Query Results
  <a href="http://i.imgur.com/uakv7e5.jpg" rel="nofollow">http://i.imgur.com/uakv7e5.jpg</a></p>
  
  <pre><code>select
  inv_mast.default_product_group,
  inv_mast.item_id,
  inv_mast.item_desc,oe_hdr.order_date,
  oe_line.qty_invoiced,
  oe_line.extended_price 
  
  from
  job_price_hdr
  
  join oe_hdr on oe_hdr.job_price_hdr_uid = job_price_hdr.job_price_hdr_uid 
  join oe_line on oe_line.order_no = oe_hdr.order_no
  join inv_mast on inv_mast.inv_mast_uid = oe_line.inv_mast_uid
  
  where
  oe_line.qty_invoiced&gt; 0
  and
  oe_hdr.customer_id = 100080
  and
  default_product_group = 'FAST'
  
  order by
  inv_mast.item_id
  </code></pre>