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

From: robert <>
Date: 25 May 2004 12:49:13 -0700
Message-ID: <>

"Laconic2" <> wrote in message news:<>...
> "robert" <> wrote in message
> > (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

Original text of this message