title: SQL Issue - Sum
body: <p>im tying to sum a Quantity in SQL, but im getting a error.
  Does anyone know what im doing wrong?
  Thanks! (sorry im not good at SQL!)
  It works fine until i try to Sum BXQTOH (add sum and group by breaks it )</p>
  <pre><code>SELECT STKMP.AWPART, STKMP.AWDES1, POPTVP.BF5PLT,              
  POPTVP.BF5VPT, SUM(STKB.BXQTOH)                                
   FROM stkmP INNER JOIN POPTVP ON BF5PT# = AWPART                                                         
   INNER JOIN STKB ON STKB.BXPLNT = POPTVP.BF5PLT                
  AND AWPART LIKE 'Z%' AND STKB.BXPART = AWPART GROUP BY BXPLNT 
  </code></pre>
  <p>I have extra rows i need to consolidate into one row... so basically for Z00002
  i need the 0 and 1 qtys summed up into one row.
  Thanks</p>
  <p><a href="https://i.stack.imgur.com/KuX3f.png" rel="nofollow noreferrer">https://i.stack.imgur.com/KuX3f.png</a></p>