Outer Join....confused

From: Danny McNabb <daniel.mcnabb_at_eku.edu>
Date: 5 Jul 2001 08:00:25 -0700
Message-ID: <ccbe6c8f.0107050700.3ee102ee@posting.google.com>

I have a query that looks like this
select stvcnty_desc,

       count(distinct saradap_pidm)
  from saradap, spraddr, stvcnty
where saradap_term_code_entry = 200210

      and saradap_styp_code = 'N'
      and saradap_pidm = spraddr_pidm
      stvcnty_code = spraddr_cnty_code(+)
      and stvcnty_code between 001 and 120
      group by stvcnty_desc

--problem is there are counties I want to display that have a count   of 0. I added the outer join and yet the county does not show up.   What am I doing wrong....is this not the way outer joins work?? Received on Thu Jul 05 2001 - 10:00:25 CDT