Re: Add zero for null in count?

Thanks for the responses. I actually figured out a solution on my own.  Below is my revised query that works.

select distinct r.dstr_nr, count(distinct x.rgsn_id) "DAILY TOTAL" from rgsn r, (select applied_dt, rgsn_id, dstr_nr from rgsn where dstr_nr between 1603 and 1700 and trunc(applied_dt) = '13-SEP-2006')x where r.dstr_nr between 1603 and 1700
and r.rgsn_id = x.rgsn_id(+)
group by r.dstr_nr
order by r.dstr_nr desc
/ Received on Thu Sep 14 2006 - 12:22:25 CDT