select apply_id,sum(charge_total_lower) from jj_t_charge_income_main where apply_id = 'Q2007-350784002-0006' group by apply_id 这句话没有问题。但我加了一个名段就不可以了。
select apply_id,pay_member,sum(charge_total_lower) from jj_t_charge_income_main where apply_id = 'Q2007-350784002-0006' group by apply_id 这句话就会出错是什么原因？
要怎么改？

select apply_id,pay_member,sum(charge_total_lower) from jj_t_charge_income_main where apply_id = 'Q2007-350784002-0006' group by apply_id,pay_member

以下是引用purana在2007-10-23 17:28:35的发言：
select apply_id,pay_member,sum(charge_total_lower) from jj_t_charge_income_main where apply_id = 'Q2007-350784002-0006' group by apply_id,pay_member

正解！

谢谢，可以了。