SELECT PARTY_ID, CUST_ACCOUNT_ID, SITE_USE_ID, COLLECTOR_ID FROM FII_COLLECTORS UNION ALL SELECT -2 PARTY_ID, -2 CUST_ACCOUNT_ID, -2 SITE_USE_ID, -1 COLLECTOR_ID FROM DUAL
View Text - HTML Formatted
SELECT PARTY_ID , CUST_ACCOUNT_ID , SITE_USE_ID , COLLECTOR_ID FROM FII_COLLECTORS UNION ALL SELECT -2 PARTY_ID , -2 CUST_ACCOUNT_ID , -2 SITE_USE_ID , -1 COLLECTOR_ID FROM DUAL