select max(a.name) as 用户姓名, b.customerid as 用户ID, sum(b.revenue)as 钱总数
from Customer a,money b
where a.id=b.customerid
group by b.customerid
from Customer a,money b
where a.id=b.customerid
group by b.customerid
select a.name as 用户姓名, b.customerid as 用户ID, sum(b.revenue)as 钱总数
from Customer a,money b
where a.id=b.customerid
group by b.customerid
select a.name as 用户姓名, a.customerid as 用户ID, b.sum(revenue) as 钱总数 from
Customer a join money b on a.id=b.customerid;