title: Populate sql column from query result
body: <p>I have 2 tables</p>
  
  <p><strong>requests</strong></p>
  
  <p><strong>requests_votes</strong></p>
  
  <p>request structure is:</p>
  
  <pre><code>id | req_name | content | hits
  ------------------------------
  1  | Sample   | Some    | NULL
  2  | Sample   | Some    | NULL
  3  | Sample   | Some    | NULL
  4  | Sample   | Some    | NULL
  5  | Sample   | Some    | NULL
  </code></pre>
  
  <p>requests_votes structure is:</p>
  
  <pre><code>id | requestid | user_id
  ------------------------
  10 | 2         | 2556
  18 | 2         | 2522
  33 | 3         | 120
  44 | 2         | 1559
  98 | 5         | 253
  </code></pre>
  
  <p>width the following query im able to calculate how votes have an item(request)</p>
  
  <pre><code>SELECT `requestid` , count( requests_votes.id ) AS totals
  FROM `requests_votes`
  INNER JOIN `requests` ON requests.id = requests_votes.requestid
  GROUP BY `requestid`
  </code></pre>
  
  <p>output:</p>
  
  <pre><code>requestid | totals
  ------------------
  2         | 3
  3         | 1
  5         | 1
  </code></pre>
  
  <p>i want to populate the <strong>hits</strong> column inside requests table with <strong>count( requests_votes.id )</strong> result.</p>
  
  <p>I've go trough the similar questions asked here on stackoverflow, but couldn't find the solution.</p>