Union Query with Oracle 7.2

Hello,

Can anyone help me with the following question?

I would like to join following tables...

TableA

Field1	Field2
A	W
B	X

TableB

Field1	Field2
A	Y
C	Z

...to get following results:

Result

Field1	Field2
A	W
B	X
A	Y
C	Z

(in any row order)

Can anyone tell me how this can be done using SQL in Oracle 7.2 (or 7.3)?

Any suggestions greatly appreciated!

Thanks.

Allen Worthington Received on Fri Mar 20 1998 - 00:00:00 CST