title: Join results of two select statements
body: <p>I have a table serving as a transaction log:</p>
  
  <pre><code>Date  Action  Qty
  11-23  ADD     1
  11-23  REMOVE  2
  11-23  ADD     3
  </code></pre>
  
  <p>I would like a query to aggregate all of ADDs and all of the REMOVEs separately for a given date.  </p>
  
  <p>Each of these select statements work fine, but they cannot be joined:</p>
  
  <pre><code>select date, sum(qty) as Added from table where action='Add' and date='11-23'
  
  natural join
  
  select date, sum(qty) as Removed from table where action='Remove' and date='11-23'
  </code></pre>
  
  <p>Can I store the results of each select statement to a table and then join those?  Is there a way to avoid this all together?</p>
  
  <p>Thanks-
  Jonathan</p>