title: Sum columns from multiple tables in MySQL
body: <p>I am trying to sum some columns from multiple tables in just one SQL query, but I seem to be getting the wrong results. I think there is a problem with the code that I have provided below. Please any help on this is appreciated.</p>
  
  <pre><code>item Names
   | id | name |
   | 1  |  AB  |
   | 2  |  CA  |
  
  table1
  | id  | interest | year |
  | 1   |   20.00  | 2014 |
  | 2   |   30.00  | 2013 |
  | 1   |   10.00  | 2013 |
  
  table2
  | id  | deposit  | year |
  | 1   |   10.00  | 2014 |
  | 2   |   10.00  | 2014 |
  </code></pre>
  
  <p>This is the query that I tried:</p>
  
  <pre><code>    SELECT 
          a.name,
          b.year,
          sum(b.interest) as 'total'
      FROM
          `table1` b
      INNER JOIN
          `item names` a
      ON
          b.id=a.id
      GROUP BY
          b.id
  
  UNION ALL
  
      SELECT 
          c.name,
          d.year,
          sum(d.deposit) as 'total'
      FROM
          `table2` d
      INNER JOIN
          `item names` c
      ON
          d.id=c.id
      GROUP BY
          d.id
  </code></pre>
  
  <p>EXPECTED RESULTS</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I am trying to find the total sum of interest and deposit for a particular year and for a particular item</p>
  
  <pre><code>|name   | year  |   total    |
  | AB    | 2014  |    30.00   |
  | AB    | 2013  |    10.00   |
  | CA    | 2013  |    30.00   |
  | CA    | 2014  |    10.00   |
  </code></pre>