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_at_comcast.com>
Date: Tue, 25 May 2004 10:00:40 -0400
Message-ID: <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
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
> to matching on order_number in both tables. all order_lines have
> a value )