Question

SQL两表联合统计查询问题

有两个表，表结构如下，表1，和表2都是通过UserID分类汇总统计进行查询，然后输出如查询，两表都有多个UserID记录，我的SQL语言在后面，现在查询的结果是，表2的统计是对的，表1的统计结果不对，表1的统计结果是表1正确的结果乘以表2UseID记录个数的和，不知道怎么解决
表1.
UserID 数据 费用
101 111 123
101 155 226
101 455 999
102 325 665
102 112 125
103 159 357
表2.
UserID 充值费用
101 55
101 65
101 188
102 555
103 755
查询：
UserID 费用 充值费用
101 ** **
102 ** **
103 ** **
104 ** **
如何通过统计表1的数据和费用和表2的费用，按用户ID号分组查询啊？

select 表1.UserID,sum(表1.数据),sum(表1.费用) (select sum(表2.充值费用 where表1.UserID=表2.UserID) from 表1 inner join 表2 group by 表1.UserID

Answer 1

select a.userid,sum(数据) as shuju,sum(费用) as feiyong,(select sum(充值费用) from 表2 where userid=a.userid) as chongzhifeiyong from 表1 order by userid

Answer 2

select a.*,a.费用*b.费用 充值费用 from
(SELECT USERID,sum(费用) 费用 FROM 表1 group by userid) a
inner join
(select userid,sum(充值费用) 费用 from 表2 group by userid) b
on a.userid=b.userid

Answer 3

SELECT
subQuery1.UserID,
subQuery1.费用,
subQuery2.充值费用
FROM
(
SELECT
UserID,
SUM(费用) AS 费用
FROM
表1
GROUP BY
UserID
) AS subQuery1,
(
SELECT
UserID,
SUM(充值费用) AS 充值费用
FROM
表2
GROUP BY
UserID
) AS subQuery2
WHERE
subQuery1.UserID = subQuery2.UserID