Re: Help required.

Could you try the following..

select n.pers_name||' a '||p.posn_name||' in '||u.unit_name||' worked '||

       a.activ_hours||' worked on '|| TO_CHAR(A.ACTIV_DATE,'DD-MON-YYYY') from position p, personnel n, activity a, unit u

where  p.posn_id = n.posn_id
  and  n.pers_id = a.pers_id
  and  u.unit_id = a.unit_id
  and  (a.pers_id,a.activ_date,a.activ_hrs) IN
         (select pers_id,activ_date,activ_hrs
          from activity
          where (activ_date,activ_hrs) in
           (select activ_date, max(activ_hrs)
            from activity
            where activ_date >= to_date('18-MAR-2002','DD-MON-YYYY')
              and activ_Date <= to_date('22-MAR-2002','DD-MON-YYYY')
            group by activ_date)

Regards
Bhooshan
bhooshan.s.prabhu_at_orbitech.co.in Received on Thu May 02 2002 - 06:46:06 CEST