title: SQL Access help in sum from 2 different tables
body: <p>i have these tables</p>
  
  <pre><code>table 1
  
  id      price
  1       30
  2       40
  3       50
  
  
  table 2
  
      id      price
      1       70
      2       5
      3       10
  </code></pre>
  
  <p>i want a query that would sum the the <code>price</code> value based on the <code>ID</code>
  like if table1.id=table2.id then sum table1.price and table2.price
  the end result should be something like this</p>
  
  <pre><code>table 3
  
      id      price
      1       100
      2       45
      3       60
  </code></pre>