I did it all in SQL with outer join. select SHIFT_DATE, nvl(round(24 * (psa.shift_end_datetime-psa.shift_start_datetime), 1),0) as total_hour, nvl(c.external_code,c.leave_type_code) ||'('||c.leave_type_code||')' as leave_type_code from pa_shift_allocation psa, leave_type_code c where psa.leave_type_code(+)=c.leave_type_code AND psa.shift_date(+) like '%$P!{p_month}' and psa.status(+) = 'A' and psa.assignment_type_code(+) = 'L' Post edited by: ktalarico, at: 2007/10/17 12:26