title: SQL: Multiplying two columns(from different tables) and Inserting/Updating(one of the tables)
body: <p>I have two tables:</p>
  
  <p><code>Stock</code>:</p>
  
  <pre><code>ItemID Quantity
  111  5.0
  222     3.0
  </code></pre>
  
  <p><code>Item</code>:</p>
  
  <pre><code>ItemID  Sellper
  111     1.0
  222     2.0
  </code></pre>
  
  <p>I want to use the <code>ItemID</code> to perform <code>Quantity*Sellper</code> and the use the result to <strong>update the Quantity field in Stock Table</strong>.</p>
  
  <pre><code>SELECT *,Stock.StockQuantity * Item.SellPer As FinaLStockQuantity 
  FROM Stock, Item 
  WHERE Stock.ItemID = Item.ItemID   
  </code></pre>
  
  <p>I can get the results of the product of two columns using the above query but can not get it to update the stock table.</p>
  
  <p>Can someone please help?
  P.S: Apologies for the horrible formatting of this post </p>