Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: brain cramp or bug: inner join returns rows w/null

Re: brain cramp or bug: inner join returns rows w/null

From: robert <gnuoytr_at_rcn.com>
Date: 25 May 2004 12:49:13 -0700
Message-ID: <da3c2186.0405251149.6f9bbba3@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 - 14:49:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US