- I'm new here. i'd make a query that let me have the following informations:
> direct Children from parent source (project manager)
> Allocation rate
> Names of subprojects
Here is the SQL I'm using:
select inv.parent_id parent,
The problem is, how can i associate the name of subprojects with INV_HIERARCHIES?