title: SQL script, STOCK returning same results
body: <p>I need help with a SQL script. I need to show the STOCK quantity of some products on a dataGrid, so there's 2 tables, one is the PRODUCT and the other is STOCK where I save all the movimentation. This is my script:</p>
  
  <pre><code>SELECT PRO_LABEL,
  
  (SELECT SUM(STO_QUANTITY) STO_QUANTITY FROM STOCK STO
  LEFT JOIN PRODUCT AS PRO ON PRO.PRO_ID = STO.PRO_ID
  WHERE PRO.PRO_ID = STO.PRO_ID) STO_QUANTITY
  
  FROM PRODUCT AS PRO
  ORDER BY PRO.PRO_ID DESC
  </code></pre>
  
  <p>the problem here is that all the results show me the same STO_QUANTITY. Each product should show it's own stock</p>