SELECT statement_number, bank_account_num FROM CE_STATEMENT_HEADERS_INT UNION SELECT csh.statement_number, aba.bank_account_num FROM ce_bank_accounts aba, ce_statement_headers csh WHERE csh.bank_account_id = aba.bank_account_id
SELECT STATEMENT_NUMBER
, BANK_ACCOUNT_NUM
FROM CE_STATEMENT_HEADERS_INT UNION SELECT CSH.STATEMENT_NUMBER
, ABA.BANK_ACCOUNT_NUM
FROM CE_BANK_ACCOUNTS ABA
, CE_STATEMENT_HEADERS CSH
WHERE CSH.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
|
|
|