I need to find out the hiearchy of my project where in i need to display my project name along with PHases that are part of the project and the tasks associated to each phase.
my output should look like this
PGM2354 PH45454 T79832
Its more like CTE in SQL server
in this table the only way to find this realationship is to have parent_id, root_id relationships, all the tasks are tied to its parents PHase and all the root_id of these phases and tasks are related tot eh PGM(project).
Activity_number field stores all the project, phase, task id details like PGM123(project) PH23232 and T244343 and the name field stores the projectname, phase and task names
Please can someone help me in writing a query for this
I am not a full time DB person and i would appreciate any help on this