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: Laconic2 <laconic2_at_comcast.net>
Date: Tue, 25 May 2004 10:00:40 -0400
Message-ID: <UJCdnTfBzsqmzC7dRVn-sQ@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. Received on Tue May 25 2004 - 09:00:40 CDT

Original text of this message

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