Unions in SQR Select Statements

["John Munkberg (Connexus)" <Johnm@CONNEXUSENERGY.COM>]

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  |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~