Hi,
I have the following problem:
There is one table that contains projects, that has fields: id, departament and cost.
Second table contains subprojects. Subproject has it's cost and foreign key to project.
I need an idea, how to make grouping query that will give: departament, cost of projects in this departament, cost of subprojects in this departament.
Please help me.