求一条SQL语句.高手进.

发布网友发布时间：2024-09-29 01:06

共1个回答

热心网友时间：2024-09-29 01:50

select sum(hst_cashserial.Amount) as 总共充值 ,sum(hst_dealrecord.prepay) as 总共消费, sum(mem_localmemberbaseinfo.Balance) as 余额 from hst_cashserial, hst_dealrecord ,mem_localmemberbaseinfo where hst_cashserial.Remark=hst_dealrecord.UserUniqueID and hst_cashserial.Remark=hst_dealrecord.UserUniqueID =mem_localmemberbaseinfo.UniqueID and hst_cashserial.Remark='210011948935'

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com