Re: Outer Join....confused

From: Frank <franjoe_at_frisurf.no>
Date: Thu, 5 Jul 2001 18:18:24 +0200
Message-ID: <zs017.2995$tD1.392011@news3.oke.nextra.no>

Hi!

I am not very good at compiling and executing queries on, for me, unknown data, in my mind,
but I think the line above the outer joined one seems to be inner joined, and (if I guess right) from the same table as "spraddr_cnty_code".

Frank

Danny McNabb <daniel.mcnabb_at_eku.edu> wrote in message news:ccbe6c8f.0107050700.3ee102ee_at_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 - 11:18:24 CDT