UNION, INTERSECT, and EXCEPT Clauses

By default, non-distinct rows are aggregated into single rows in a UNION, INTERSECT, or EXCEPT operation. Use
the ALL clause to retain non-distinct rows.

I hope it should read distinct. If not 1) the little test I just tried returns the wrong result and 2) I can't get my head round why

Roy Lambert

Roy,

<< I hope it should read distinct. If not 1) the little test I just tried
returns the wrong result and 2) I can't get my head round why >>

If you mean the first "non-distinct" reference, then no, it is is correct in
the manual.  Non-distinct rows are effectively made distinct in a UNION,
INTERSECT, or EXCEPT operation.

If what you're seeing doesn't jive with that, then send me the test that
you're using and I'll take a look.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Its me - typing up a response here did something to my brain and I realised I had distinct and non-distinct reversed - sorry.

Roy Lambert