Re: aggregation over two hierarchies

On 22 Feb 2005 13:00:01 -0800, "navrsale" <navrsalemile_at_yahoo.ca> wrote:

>Query must process each row in JOB_REPORT table and aggregate the
>number of employees when these numbers represent the "history" of
>particular JOB_ID to correct existing value in JOB_REPORT table (to
>"prorate" the number of employees in JOB_REPORT table based on the
>history of given JOB_ID represented inside JOB table).
>
>thanks,
>mile

How much do you pay? Do you realize Usenet is a volunteer business and you can't expect people to sit down for half an hour or more to write your query?

--
Sybrand Bakker, Senior Oracle DBA