criteria on the outer table

I have 2 tables

obj

   code
   description

and

evt

   object
   event
   date

join by the outer join evt_object(+)=obj_code

criteria= where evt_date between :p_start and :p_end

i want to select all the obj_code and description of the obj table , count the number of events for each obj_code even when no event exist during the period (criteria on the outer join)

how can i do? Received on Tue Sep 17 2002 - 06:36:59 CDT