http://www.cnblogs.com/jackluo/p/3475498.html
select p.
*,g.roleName,pg.srcType
from t_gold_pay_add p
left join gRole g
on p.roleID
=g.roleID
left join gPay pg
on pg.roleID
=p.roleID
这上面那边语句，容易造成数据重复
select distinct p.id,p.
*,g.roleName,pg.srcType
from t_gold_pay_add p
left join gRole g
on p.roleID
=g.roleID
left join gPay pg
on pg.roleID
=p.roleID
加入了distinct 就好很多，但是遇到 了一个sum 求和的问题,没有找到解决方案，手动写的
有兴趣的同学，可以告诉我一下
select distinct p.id,
sum(p.gold)
from t_gold_pay_add p
left join gRole g
on p.roleID
=g.roleID
left join gPay pg
on pg.roleID
=p.roleID
转载请注明原文地址: https://ju.6miu.com/read-5743.html
