title: How to join SQL statements with different where clause on same column of same table
body: <p>I have 2 statements in sqlite</p>
  
  <p>1st Statement:</p>
  
  <pre><code>Select SUM(GrossQty) As GQTY, SUM(NetQty) As NQTY
    From NSales 
    Where IMonth=5 And IYear=2012 And IDay&gt;15
  </code></pre>
  
  <p>Result:</p>
  
  <blockquote><pre>
  GQty  NQty
   30    25
  </pre></blockquote>
  
  <p>2nd Statement</p>
  
  <pre><code>Select SUM(GrossQty) As GQTY, SUM(NetQty) As NQTY
    From NSales 
    Where IMonth=6 And IYear=2012 And IDay&lt;10
  </code></pre>
  
  <p>2nd Result:</p>
  
  <blockquote><pre>
  GQty  NQty
   20    15
  </pre></blockquote>
  
  <p>How can I combine these statements so that I get both these results added together like this?</p>
  
  <p>Desired Result:</p>
  
  <blockquote><pre>
  GQty  NQty
   50    40
  </pre></blockquote>