title: How to sum or add two values by using SQL command
body: <p>How to add them together?
  Need to be in vb.net</p>
  
  <p>Two value statement as below:</p>
  
  <pre><code>(SELECT SUM(ChildName) FROM Child SA WHERE SA.Name=A.Name AND SA.Health_Status=1 AND SA.Parrent_ID IS NOT NULL) AS Present_CHILD
  
  (SELECT SUM(LATE_COMING_CHILD) FROM LATE_COME SB WHERE SB.Name=A.Name) AS LATE_CHILD
  </code></pre>