TecTao Posted February 8, 2008 Share Posted February 8, 2008 I can't seem to find the function to sum a column of numbers. the column $pay_amount is monthly amounts for a program. My select statement for a particular member produces a table of with each program and amount the member has signed up for. I need to get the sum of the $pay_amount column. This is an easy one but I just can remember or find it in googling. Thanks, m Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted February 8, 2008 Share Posted February 8, 2008 Just use SUM. SELECT SUM(pay_amount) as total FROM table Quote Link to comment Share on other sites More sharing options...
TecTao Posted February 8, 2008 Author Share Posted February 8, 2008 I'm familiar with the sum (pay_amount) as total in the Sql statement. but since I am joining about 4 tables and the 'pay_amount' is not in the first table, I was hoping there was a command that could total the numbers in the column rather then write a sql statement. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.