Findind cumulative amounts through SQL query on web develop?

Discuss how to use and promote Web standards with the Mozilla Gecko engine.
Post Reply
kokilasoral
New Member
Posts: 1
Joined: June 1st, 2016, 11:19 pm

Findind cumulative amounts through SQL query on web develop?

Post by kokilasoral »

stressed with a SQL query I have a gathering process and I need to have a query that display me each day how far we have gathered so far through the current month in a increasing way. I have all the info in one table named Prodo the date field is Process Date and the amount is in l_camnt Field.
So far I have this:
Query:
SELECT
Prodo.ProcessDate, SUM(Procesado.l_camnt) AS Monto
FROM
Prodo
WHERE
Prodo.ProcessDate >= Procesado.ProcessDate
GROUP BY
Prodo.ProcessDate
Table value
Table Name: Procesado
Process_Date l_camnt
05/26/2015 $1000
05/26/2015 $500
05/27/2015 $2000
05/27/2015 $1000
05/28/2015 $5000
Desired output
05/26/2015 $1500
05/27/2015 $4500
05/28/2015 $9500
User avatar
Pim
Posts: 2215
Joined: May 17th, 2004, 2:04 pm
Location: Netherlands

Re: Findind cumulative amounts through SQL query on web deve

Post by Pim »

This is not quite the kind of forum to ask that kind of questions. For one thing, I don't see how this has anything to do with web development. And for another, I don't see a question.
Groetjes, Pim
Post Reply