title: SQL Combining 2 result sets in an ordered way
body: <p>Is there a way to order 2 queries into a single result set?</p>
  
  <p>More specifically, if I had 2 queries : </p>
  
  <pre><code>select 'line',product, numeric_value from numbertable order by product;
  
  select 'Total',product, sum(numeric_value) from numbertable group by product;
  </code></pre>
  
  <p>Is there a way to combine the two queries so that the result set would look like this:</p>
  
  <pre><code>    Type      Product      numeric_value
  
      line      item1        23
      line      item1        57
      line      item1        23
      Total     item1        103
      line      item5        20
      line      item5        50
      line      item5        60
      Total     item5        130
      ...
  </code></pre>
  
  <p>Basically, I'm looking to list all of the item records of a product, then show a sum for them, then list all the item records of the next product, etc.</p>
  
  <p>Is there a way to do this, or is it an impossible task?
  Thanks :)</p>