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