title: Access sql groupby
body: <p>I Have a Table1 </p>
  
  <pre><code> pbsc   qty   wt
  
   pbsc1   1    0  
   pbsc2   2    10
   pbsc3   1    0
   pbsc2   2    9    
   pbsc1   0    8
   pbsc4   9    9
  </code></pre>
  
  <p>I'm trying to get 2 results sets(2 query tables) from Table1 </p>
  
  <p>Sum up qty and wt if pbsc has similar data,for that query i used </p>
  
  <blockquote>
    <p></p>
  </blockquote>
  
  <pre><code>SELECT Table1.pbsc, sum(Table1.qty) As quantity , sum(Table1.wt) As
  &gt; Weight
  &gt;       FROM Table1 group by Table1.pbsc;
  </code></pre>
  
  <p>which gives me</p>
  
  <pre><code>pbsc    quantity    Weight
  pbsc1   1             8
  pbsc2   4            19
  pbsc3   1             0
  pbsc4   9             9
  </code></pre>
  
  <p>But i'm trying to get only pbsc1,pbsc2 as one result set since they occur more than once in a Table1, as <strong>result1</strong>  </p>
  
  <pre><code>  pbsc    qty    wt
    pbsc1     1     8
    pbsc2     4     19
  </code></pre>
  
  <p><strong>result2</strong> should be like (since pbsc3,pbsc4 occur only once)</p>
  
  <pre><code>  pbsc   qty   wt
    pbsc3   1    0
    pbsc4   9    9
  </code></pre>