title: how to sum a column from one table and group the sum using data from column of another table
body: <p>I am really having problem trying to sum up a column of one table and then group it according to the data from another table. the only common key that they have is account number.</p>
  
  <p>here is the scenario</p>
  
  <pre><code>table 1.
  
  account_no  volume  read_date
  1            32      12016
  2            22      12016
  3            20      12016
  4            21      12016
  5            54      12016
  3            65      12016
  7            84      12016
  8            21      12016
  9            20      12016
  10           30      12016
  </code></pre>
  
  <p>=========================================================</p>
  
  <pre><code>table 2
  
  account_no  Zone
  1            A
  2            A
  3            B
  4            B
  5            A
  3            A
  7            B
  8            B
  9            C
  10           C
  </code></pre>
  
  <p>Result</p>
  
  <pre><code>Zone Total
  A     173
  B     146
  C     50
  </code></pre>
  
  <p>so far this is how my query goes</p>
  
  <pre><code>Select sum(volume) as Total, read_date as bDate 
  GROUP BY bDate 
  ORDER By bDate
  </code></pre>
  
  <p>it was able to sum all the volumes based on the read_date
  any help would be much appreciated...</p>