select merchant_code,merchant_name,(select sum(history_amount) from history where merchant_code=b.merchant_code) from merchant b order by merchant_code
select merchant_code,merchant_name,(select sum(history_amount) from history where merchant_code=b.merchant_code) from merchant b order by merchant_code
select a.merchant_code,sum(a.history_amount),b.merchant_name from history a,merchant b where a.history_virement=1 and a.merchant_code=b.merchant_code group by a.merchant_code ,b.merchant_name order by a.merchant_code
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货