I have a very simple application with to tables. One is Projects with an id, name and an hours field. The second is Tasks with a related Project field, a description and the amount of hours spent to complete. I need to show the total amount of hours per project. Some way to sum all hours spent on all tasks that belong to a particular project.
What is the best way to accomplish this?
What is the best way to accomplish this?