id | uid | invite_uid | |
---|---|---|---|
1 | 11 | 204 | |
2 | 12 | 204 |
id | uid | money |
---|---|---|
1 | 204 | 10 |
2 | 204 | 10 |
执行SQL语句
select sum(b.money) as money
from tableB b join tableA a on a.invite_uid = b.uid group by a.invite_uid
出现的结果:
money |
---|
40 |
那么,为什么会出现这种情况呢?
id | uid | invite_uid | |
---|---|---|---|
1 | 11 | 204 | |
2 | 12 | 204 |
id | uid | money |
---|---|---|
1 | 204 | 10 |
2 | 204 | 10 |
执行SQL语句
select sum(b.money) as money
from tableB b join tableA a on a.invite_uid = b.uid group by a.invite_uid
出现的结果:
money |
---|
40 |
那么,为什么会出现这种情况呢?