Re: Use of Union

From: Alan <alanshein_at_spambuster.erols.com>
Date: Mon, 26 Mar 2001 16:04:53 -0500
Message-ID: <99oart$ph$1@bob.news.rcn.net>

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"

"James Chapman" <JC121123_at_nospam.ncr.com> wrote in message news:3abf91f9$1_at_rpc1284.daytonoh.ncr.com...
> Evidently, you were never exposed to set theory in your mathematical
> studies.
>
> In set theory, the union of 2 sets A and B is defined to be the set of all
> members of A and all members of B.
>
> "bpfh" <daniel_page_at_yahoo.fr> wrote in message
> news:99nkrk$k5a$1_at_s1.read.news.oleane.net...
> > Hi,
> >
> > I've been running over an SQL tutorial, which I have grasped, except for
the
> > UNION instruction.
> >
> > A part from one of the sides in the American Civil War, what is a union?
I
> > do not understand the explanation, or the code (or the code result in
> > Access)...
> >
> > Anyone got a quick explanation? All comments accepted...
> >
> > Cordially,
> >
> > Daniel Page
> >
> >
>
>
Received on Mon Mar 26 2001 - 15:04:53 CST