Re: using UNION

["Cullina, Adam" <cullinaa@UMSYSTEM.EDU>]

Neither... but this should work (works for me w/Oracle 8 and SQR)
(Note the commas in the after the column names after the union)

BEGIN-SELECT
BANK_SETID
BANK_CD
BANK_ACCT_KEY

FROM PS_CUST_MICR_TBL
WHERE REMIT_FROM_CUST_ID = $CUST_ID
AND SETID = $SETID

UNION SELECT
BANK_SETID,
BANK_CD,
BANK_ACCT_KEY,
FROM PS_VNDR_BANK_ACCT

WHERE REMIT_FROM_CUST_ID = $CUST_ID
AND SETID = $SETID
END-SELECT

-----Original Message-----
From: Jim Ebert [mailto:james_ebert@PEOPLESOFT.COM]
Sent: Thursday, December 14, 2000 8:46 AM
To: SQR-USERS@list.iex.net
Subject: using UNION


Can anyone tell me the syntax of using the UNION clause in SQR.  I can
speculate a few ideas, but dont know, and wanted to double-check

possibilities?...............................

BEGIN-SELECT
BANK_SETID
BANK_CD
BANK_ACCT_KEY
FROM PS_CUST_MICR_TBL
WHERE REMIT_FROM_CUST_ID = $CUST_ID
AND SETID = $SETID
END-SELECT
UNION
BEGIN-SELECT
BANK_SETID
BANK_CD
BANK_ACCT_KEY
FROM PS_VNDR_BANK_ACCT
WHERE REMIT_FROM_CUST_ID = $CUST_ID
AND SETID = $SETID
END-SELECT


or????.........................

BEGIN-SELECT
BANK_SETID
BANK_CD
BANK_ACCT_KEY
FROM PS_CUST_MICR_TBL
WHERE REMIT_FROM_CUST_ID = $CUST_ID
AND SETID = $SETID
UNION
BANK_SETID
BANK_CD
BANK_ACCT_KEY
FROM PS_VNDR_BANK_ACCT
WHERE REMIT_FROM_CUST_ID = $CUST_ID
AND SETID = $SETID
END-SELECT