SELECT PARTY.JGZZ_FISCAL_CODE NIF_CODE FROM HZ_CUST_ACCOUNTS CUST_ACCT, HZ_PARTIES PARTY WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID UNION SELECT NUM_1099 NIF_CODE FROM PO_VENDORS
View Text - HTML Formatted
SELECT PARTY.JGZZ_FISCAL_CODE NIF_CODE FROM HZ_CUST_ACCOUNTS CUST_ACCT , HZ_PARTIES PARTY WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID UNION SELECT NUM_1099 NIF_CODE FROM PO_VENDORS