title: SQL Update & INNER JOIN
body: <p>I'm trying to update a specific column in my DB (Using MSSQL) </p>
  
  <p>I have wrote a query to return the values already, but the problem I can't update the other table with the generated values from (More than one row) I tried using a variable to declare them and then update the table, but the problem it returns more than one value, so I wonder how may I update the table using these values.</p>
  
  <p>My Select query: </p>
  
  <pre><code>SELECT SUM(_Items.MagParam1) + SUM(_Items.MagParam2) AS Test11 
  FROM _Char 
  INNER JOIN _Inventory 
      ON _Char.CharID = _Inventory.CharID
  INNER JOIN _Items 
      ON _Inventory.ItemID = _Items.ID64 
   WHERE _Inventory.Slot BETWEEN 1 AND 13  AND _Inventory.ItemID &gt; 0
  GROUP BY [_Char].[CharName16],[_Char].[CurLevel],[_Char].[CharID]
  </code></pre>
  
  <p>So this query returns a value for every CharID I have, I want to update all rows in _Char with it's generated value from the previous query.</p>
  
  <p>Thanks in advance =)</p>