title: Writing a SQL Update statement
body: <p>I need to know how to write a SQL statement for the following senario;</p>
  
  <p>I have a table, which consist of 2 columns. <code>ParentName</code> and <code>No_Of_Kids</code>. so say we have a record called parent <code>A</code> and parent <code>A</code> had 2 kids.(in 2008)</p>
  
  <p>Now in 2011 Parent <code>A</code> has got another 3 kids, so i need to update this table, to say Parent <code>A</code> has 5 kids altogether.</p>
  
  <pre><code>UPDATE ParentKidsTable
  SET parentName=value, No_Of_kids=??? // (how to write the SQL no. of Kids in 2008 + no. of kids in 2011)
  WHERE parentName=some_value
  </code></pre>