Adding rows from two tables into a new table.

From: <screwbai_at_my-deja.com>
Date: Sat, 02 Oct 1999 17:11:01 GMT
Message-ID: <7t5eau$v9u$1@nnrp1.deja.com>

I have two table that I want to add the rows together into one table.

Example

table1:

---

A B
C D

table2

---

E F
G H

Then I want to end up with a table that has all four rows in it like this.
tableresult:

---

A B
C D
E F
G H

I can acomplish this by creating a temporary table and select into it.Or having a permanet table that I truncate everytime I execute the process. I am using a the tableresult as a virtual table in a cursor. So I am trying to avoid the use of temporary tables. Can something like this be done in a select statement.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 02 1999 - 12:11:01 CDT