title: Combine two Mysql SUM select query to one query
body: <p>I have below two query's SUM the values<br>
  <strong>Query1:*</strong>  </p>
  
  <blockquote>
    <p>SELECT SUM(price) FROM TABLE1 WHERE <code>acc_id</code> = '555'</p>
  </blockquote>
  
  <p><strong>Query2:</strong>  </p>
  
  <blockquote>
    <p>SELECT SUM(price) FROM TABLE2 WHERE <code>account</code> = '555' &amp;&amp; active='1'</p>
  </blockquote>
  
  <p>I try to combine this two query but give wrong sum result , for example if <code>query1 sum is: -86500</code> and <code>Query2 sum is: 76000</code> , RESULT must be <code>-10500</code> but result shown with a number like <code>-486000</code></p>
  
  <p>I'm trying like this, but i'm not getting expected result. </p>
  
  <pre><code>SELECT SUM(t1.price + t2.price) AS TotalCredit 
  FROM TABLE1 AS t1, TABLE2 AS t2 
  WHERE t1.`acc_id` = '555' &amp;&amp; t2.`Account`='555' &amp;&amp; t2.`Active`='1'
  </code></pre>
  
  <p>Table image : <img src="https://i.stack.imgur.com/8Rv38.jpg" alt="enter image description here"></p>