Re: Union Query with Oracle 7.2

Try

Select Field1, Field2
  From TableA
Union All
Select Field1, Field2
  From TableB
Order By Field1,Field2 <<< if required

John Thwaites
AlliedSignal Polymers Division

Allen Worthington wrote:

> 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