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
Findind cumulative amounts through SQL query on web develop?
-
- New Member
- Posts: 1
- Joined: June 1st, 2016, 11:19 pm
- Pim
- Posts: 2215
- Joined: May 17th, 2004, 2:04 pm
- Location: Netherlands
Re: Findind cumulative amounts through SQL query on web deve
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