sql - 在 2 个表之间按组求和

Question

我，我试图在 2 个表之间按组求和。基本上我试图只显示表'Count'和'Bank_code'表'MoneyMovements'组的每个SUM（）。这可能吗？。我尝试了左连接（包括“计数”中的“MoneyMovements”）。但我不明白如何分离总和......有什么建议吗？我在 VB.NET 中使用 ACCESS 2007

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       |
+-----+--------------+

标签： sqlms-access

Answer 1

你需要join像group by：

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