Q:

Sum by groups between 2 tables

I, im trying to Sum by groups between 2 tables. Basically im trying to show only the Table 'Count' with each SUM() of Table 'MoneyMovements' group by 'Bank_code'. Is this possible?. I tryed with Left join (including the 'MoneyMovements'in 'Count'). but i dont understand how to separe the sum... Any suggestion?. Im using ACCESS 2007 in VB.NET
Table 'Count'
+----+--------------+
|Code|Bank          |
+----+--------------+
|1   |MACRO         |
+----+--------------+
|2   |Santender Rio |
+----+--------------+
|3   |Galicia       |
+----+--------------+

Table 'MoneyMovements'

+-----+--------------+
|Money|Bank_code     |
+-----+--------------+
|200  |1             |
+-----+--------------+
|300  |1             |
+-----+--------------+
|0    |2             |
+-----+--------------+
|500  |3             |
+-----+--------------+
|100  |3             |
+-----+--------------+

Response i Want:
+-----+--------------+
|Money|Bank          |
+-----+--------------+
|500  |MACRO         |
+-----+--------------+
|0    |Santender Rio |
+-----+--------------+
|600  |Galicia       |
+-----+--------------+

A:

You need join with group by like:
Select c.Code, sum(m.Money) as Money
From Count c
inner join MoneyMovements m on c.Code = m.Bank_code
group by c.Code

