Welcome to WebmasterWorld Guest from 54.167.29.254

Forum Moderators: open

Message Too Old, No Replies

MySQL Sum() -- Returning Column valuses and Sum() of column valuses in

     
5:00 pm on Jun 9, 2011 (gmt 0)

New User

5+ Year Member

joined:June 9, 2011
posts:1
votes: 0


I have this for my query.

select id, cust#, payment, date group by cust# As expected it returns the results. I need it to return each column value plus a value for the sum(payment)as totalpayments

I can't figure it out as this only will return total for payments and not each payment amount plus the total

select id, cust#, sum(payment), date group by cust#

This is what i want in a sense even though this is not a valid query select id, cust#, payment, sum(payment) AS totalpayments, date group by cust#