select u.money_remain,
ba.price,ba.total_count,
ba.total_price,
bc.company_name,
bc.total_balance
from users u , boss_customer bc, boss_addmoney ba
where bc.belong_sales = 'jijun' and u.user_id = bc.user_id and u.username = ba.name
group by u.username
order by ba.name,ba.add_date
之前搞项目 组长说用group by 查询 试了下 顺序不好排
加了order by 其实就是可以用了
囧。。 我还一直抵抗说group by 有问题