I'm not too sure I understand how dynamic the data can be. The only
static components I assumed in the query is the types (either 'Begin
Headcount', 'Hired' and 'Terminated'). If those also can change, let us
know, and we'll need to think of another solution. The levels can be
anything, and the query would work anyway. I also thought afterwards
that you probably need full outer joins between (inline) tables a, b
and c, to account for the fact that any of those might have 0 entries.
You also probably also need nvl in the select clause for a and b.
HTH
Daniel
Received on Mon Jan 30 2006 - 07:34:08 CST
