Ramnik
Registered User.
- Local time
- Today, 19:24
- Joined
- Jul 12, 2012
- Messages
- 145
hello everyone,
i have a production application in which i have a table named daily_production with fields as ( prod_id, date, productname, qty ).
now i want a daily production query as
date : xx-xx-xxxx
productname | qty | monthlysum(for thsi product) | daily average |
i want this on a single query so that i can make a report out of this .
this seems quite simple but i m stuck . any help would be much appreciated. thankssssssss
i have a production application in which i have a table named daily_production with fields as ( prod_id, date, productname, qty ).
now i want a daily production query as
date : xx-xx-xxxx
productname | qty | monthlysum(for thsi product) | daily average |
i want this on a single query so that i can make a report out of this .
this seems quite simple but i m stuck . any help would be much appreciated. thankssssssss