Re: Unions in SQR Select Statements

["Kulshrestha, Alok" <ALOKKULSHRESTHA@IMF.ORG>]

Yes, You can use UNION in SQR.
Second Select onwards it follows all Database syntax rules. The following
select statement should be written as following :
-----------------------
BEGIN-SELECT
empno
        DO results
from employee

UNION

select empno

>From Supervisors
END-SELECT
--------------------
Hope it helps you !
-alok

On Tuesday, October 27, 1998 2:19 PM, John Munkberg (Connexus)
[SMTP:Johnm@CONNEXUSENERGY.COM] wrote:
: Is is possible to use UNIONS in SQR?   (Oracle 7.3 DB)
:
: I want to do something like this (forgive the syntax, that's my
: question):
:
: BEGIN-SELECT
: empno
:   DO results
:   from employee
:   UNION
: empno
:   DO results
:   from supervisors
: END-SELECT
:
: I would then feed each distinct empno into another procedure (results)
: to collect data and print the results.
:
: I know I could create a view from which to select all the empnos, but
: then there is maintenance, etc.
:
:
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: ~~~~~~~~~
: |   John E. Munkberg    |   CONNEXUS  ENERGY   |
: JohnM@CONNEXUSENERGY.com     |
: |     612.323.2782      |      Ramsey, MN     |
: http://WWW.CONNEXUSENERGY.com  |
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: ~~~~~~~~~