Re: Use of Union

From: James Chapman <JC121123_at_nospam.ncr.com>
Date: Mon, 26 Mar 2001 18:02:01 -0800
Message-ID: <3abff3b8@rpc1284.daytonoh.ncr.com>

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 Mon Mar 26 2001 - 20:02:01 CST