VB中的SELECT 连结汇总问题

Question

本人建有一个数据库sale,有两个表表1结构和数据                           表2结构和数据ID        province                       ID        salenumber
01        北京                           01          5
02        上海                           02          3
03        广东                           01          2 
04        浙江                           03          3
                                         02          4 
                                         04          2 
                                         02          6
                                         03          1请问如何使用SELECT 联合查询方式实现如下汇总记录集合
      province        totalsalenumber
         北京              7
         上海              13
         广东              4
         浙江              2 
在线等急用,谢谢帮忙

Answer 1

ELECT 表1.province, Sum(表2.salenumber) AS totalsalenumber
FROM 表1 INNER JOIN 表2 ON 表1.ID = 表2.ID
GROUP BY 表1.province;

Answer 2

SELECT 表1.province, Sum(表2.salenumber) AS totalsalenumber
FROM 表1 INNER JOIN 表2 ON 表1.ID = 表2.ID
GROUP BY 表1.province;

Answer 3

问题解决了，非常感谢quren!!!