楼主说的不够详细,最好把表的结构及希望的结果贴出来!!难道这样?select count(tt.money),tt.user from (select a.money1,b.user,b.bank from orders a INNER JOIN users b on a.orders_own=b.realname)tt group by tt.user
select sum(tt.money),tt.user from (select a.money1,b.user,b.bank from orders a INNER JOIN users b on a.orders_own=b.realname)tt group by tt.user我是求这个用户在订单表里的总金额楼上的非常感谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货