Thread: sum of sum
View Single Post
  #1 (permalink)  
Old 03-20-2008, 12:08 PM
amkma amkma is offline
WebProWorld New Member
 

Join Date: Oct 2004
Location: London
Posts: 6
amkma RepRank 0
Default sum of sum

Hi everyone.
Good day.

I have a table 'payments' with 9 fields.
id,
client_name,
total_amount,
deposit_paid,
deposit_paid_on_date,
1st_installment,
installment_paid_on_date,
2nd_installment_paid,
2nd_installment_paid_on_date

I want to get the the sum of each payment, for which I have used the 'sum()' in the query.

But how can I get the sum of the sum (deposit_paid + 1st_installment + 2nd_installment) received today.

Regards.
Reply With Quote