Re: Use of Union

Yes, that's ANSI. It seems to me that UNION (without ALL) is the true union. I don't recall any concept of duplicates in set theory.

"JRStern" <JRStern_at_gte.net> wrote in message news:3abfd637.31808748_at_news.gte.net...
> On Mon, 26 Mar 2001 16:04:53 -0500, "Alan"
> <alanshein_at_spambuster.erols.com> wrote:
> >Except that in Oracle SQL there is a UNION and a UNION ALL. UNION ALL is
 the
> >true union. UNION is more like a "union distinct"
>
> Believe that's ANSI.
>
> J.
>
Received on Tue Mar 27 2001 - 04:02:01 CEST