Re: brain cramp or bug: inner join returns rows w/null
Date: 25 May 2004 12:49:13 -0700
Message-ID: <da3c2186.0405251149.6f9bbba3_at_posting.google.com>
"Laconic2" <laconic2_at_comcast.net> wrote in message news:<UJCdnTfBzsqmzC7dRVn-sQ_at_comcast.com>...
> "robert" <gnuoytr_at_rcn.com> wrote in message
> news:da3c2186.0405250459.28ffbb6b_at_posting.google.com...
>
> > (still doesn't explain why value could ever be NULL; i've restricted
> > to matching on order_number in both tables. all order_lines have
> > a value )
>
> I didn't catch this point the first time around. Did you say this earlier?
>
> Test your data to make sure this is true. Maybe there's something about the
> data that's different than what you expect.
>
> Also, take a look at Oracle's execution plan to make sure that it's not
> doing an outer join, for some reason.
if i add a group by i get the "correct" number of rows. ah. this forces a cursor, which resolves at the row level, etc.
the mystery continues.
robert Received on Tue May 25 2004 - 21:49:13 CEST