Re: Use of Union

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 - 23:04:53 CEST