it works very well ....
u need do something like
begin-select
A.EMPID
!DO SOMETHING
FROM TABLE1 A
WHERE A.EMPID = 'XYZ"
UNION
SELECT
B.EMPLOYEE
FROM TABLE2 B
WHERE DEPTID="CFDF"
END-SELECT
later refer the vars by &A.EMPID ....
-----Original Message-----
From: David Fordham [mailto:dfordham@SUMMITTECH.COM]
Sent: Wednesday, November 03, 1999 11:41 AM
To: Multiple recipients of list SQR-USERS
Subject: Unions in SQR
Hi all,
Anyone ever have eny luck doing an Oracle union in an SQR?? I have tried
all day to get this to work but to no avail.
TIA,
David Fordham
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
S U M M I T T E C H N O L O G I E S, I N C.
http://www.summittech.com dfordham@summittech.com
8921 E Chenango Ave 303.740.8791
Greenwood Village, CO 80111 888.833.7360 Toll Free
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~