Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query not returning same results when displaying one column less
I think the outer joins are only on the c1 table, so selecting a.toolid
misses the outer join if no c1 values are selected. Either use
c1.toolid in the select or outer the a.
And listen to Daniel about patching. Look up "wrong results" in the bugfix docs if you need convincing.
jg
-- @home.com is bogus. http://news.com.com/U.S.+makes+first+arrest+for+spim/2100-7355_3-5584574.html?tag=nefd.topReceived on Tue Feb 22 2005 - 17:05:42 CST