title: sql using select and adding to a table
body: <pre><code>SELECT `pro`.`St`, `s`.`Quantity`
      FROM `s`
      LEFT JOIN `web`.`pro` ON `s`.`Pro_id` = `pro`.`ProdID`
  </code></pre>
  
  <p>the above query results in a table like</p>
  
  <pre><code>    st          quantity
      132             1
      11              1 
  </code></pre>
  
  <p>st is from one table and quantity is from another 
  using this select statement I want to add the resulting quantity to the st row in the other table.</p>
  
  <p>Basically updating the second table by adding the quantity i get from this select statement.</p>