MSSQL数据库联表查询求助

[daviy1980]

现在有2个数据表：
表test_tuan_ti：字段分别为abc，如图：


表test_yan_piao：字段为jc，如图：



两个表的c字段对应，现在想联表查询得出对应c字段abj合计数，如excel表格截图那样：


求mssql查询命令。谢谢！！

[daviy1980]

请各位老师们帮帮忙。

[RINK_1]

SELECT C,SUM(a) AS TOTAL_A,SUM(b) AS TOTAL_B,SUM(j) AS TOTAL_J FROM test_tuan_ti A JOIN test_yan_piao B ON A.C=B.C GROUP C

[RINK_1]

引用 2 楼 RINK_1 的回复:

SELECT C,SUM(a) AS TOTAL_A,SUM(b) AS TOTAL_B,SUM(j) AS TOTAL_J FROM test_tuan_ti A JOIN test_yan_piao B ON A.C=B.C GROUP C

应该是GROUP BY C

[RINK_1]

引用 4 楼 daviy1980 的回复:

[quote=引用 3 楼 RINK_1 的回复:][quote=引用 2 楼 RINK_1 的回复:]SELECT C,SUM(a) AS TOTAL_A,SUM(b) AS TOTAL_B,SUM(j) AS TOTAL_J FROM test_tuan_ti A JOIN test_yan_piao B ON A.C=B.C GROUP C

应该是GROUP BY C[/quote] 谢谢您的回答！但我按您的语句执行，却还是会重复统计： [/quote]

SELECT A.C,TOTAL_A,TOTAL_B,TOTAL_J 
FROM (SELECT C,SUM(a) AS TOTAL_A,SUM(b) AS TOTAL_B FROM test_tuan_ti GROUP BY C) AS A
JOIN (SELECT C,SUM(j) AS TOTAL_J  FROM test_yan_piao GROUP BY C) B ON A.C=B.C

[daviy1980]

谢谢！

引用 5 楼 RINK_1 的回复:

[quote=引用 4 楼 daviy1980 的回复:][quote=引用 3 楼 RINK_1 的回复:][quote=引用 2 楼 RINK_1 的回复:]SELECT C,SUM(a) AS TOTAL_A,SUM(b) AS TOTAL_B,SUM(j) AS TOTAL_J
FROM test_tuan_ti A
JOIN test_yan_piao B ON A.C=B.C
GROUP C

应该是GROUP BY C[/quote]


谢谢您的回答！但我按您的语句执行，却还是会重复统计：
[/quote]

SELECT A.C,TOTAL_A,TOTAL_B,TOTAL_J 
FROM (SELECT C,SUM(a) AS TOTAL_A,SUM(b) AS TOTAL_B FROM test_tuan_ti GROUP BY C) AS A
JOIN (SELECT C,SUM(j) AS TOTAL_J  FROM test_yan_piao GROUP BY C) B ON A.C=B.C

[/quote]

[daviy1980]

引用 3 楼 RINK_1 的回复:

[quote=引用 2 楼 RINK_1 的回复:]SELECT C,SUM(a) AS TOTAL_A,SUM(b) AS TOTAL_B,SUM(j) AS TOTAL_J
FROM test_tuan_ti A
JOIN test_yan_piao B ON A.C=B.C
GROUP C

应该是GROUP BY C[/quote]


谢谢您的回答！但我按您的语句执行，却还是会重复统计：