title: sql for 3 table query for sales total
body: <p>I have 3 tables
  Table A</p>
  <pre><code>geographies  
  Atlanta
  Miami
  </code></pre>
  <p>Table B</p>
  <pre><code>geographies stores  month
  Atlanta     1       1
  Atlanta     2       1
  Atlanta     1       2
  Miami       2       1
  Miami       3       1
  </code></pre>
  <p>table C</p>
  <pre><code>Stores  months   Sales
  1        1         100
  1        2          50
  2        1          25
  3        1          10
  </code></pre>
  <p>how do i create a report like this</p>
  <pre><code>Geography  Month TotalSales
  Atlanta     1     xxx
  Atlanta     2     xxxx
  Miami       1     xxxxx
  </code></pre>
  <p>thanks for the help</p>