SQL语句的问题

nply 发布于 2007-10-23 17:27， 1516 次点击

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 这句话就会出错是什么原因？
要怎么改？

3 回复

purana2007-10-23 17:28

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

ILoveMK2007-10-23 17:32

以下是引用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

正解！

nply2007-10-23 19:23

谢谢，可以了。