Re: Use of Union

From: Jan Hidders <hidders_at_REMOVE.THIS.win.tue.nl>
Date: 26 Mar 2001 15:05:02 GMT
Message-ID: <99nlqu$8vi$1_at_news.tue.nl>

bpfh wrote:
>
> I've been running over an SQL tutorial, which I have grasped, except
> for the UNION instruction.

The union simply takes two tables with the same columns and collect all their records/tuples into one table. So, the union of

<I hope you are using a monospace font here :-)>

A B

---

1 2
3 4

and

A B

---

2 3
4 1

becomes

A B

---

1 2
3 4
2 3
4 1

Kind regards,

-- 
  Jan Hidders

Received on Mon Mar 26 2001 - 17:05:02 CEST