Re: Query not returning same results when displaying one column less

Steven Howes wrote:

> wow, what an insightful answer. I bet that helped mark lots...
>
> There may be a reason that the server is unpatched and an older version. Why not trying to answer the question he posted first then tell him what version he should be running later.
>
> My guess(I'm by no means an expert, just a hack) I'd guess that there are some Null values in your "a" table that are causing the discrepancies. Try running both queries and look for one instance that exists in one result set but not the other. You might be able to narrow things down by looking at the exceptions.
>
> Steve

It might if the problemis a bug that was corrected in 8.1.7.1.

If you think your answer is correct create a test table and try it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)