Ajuda em Query

[Leonardo LitzParticipante]

Segue:


SELECT T1.CLEARING_PERIOD,
T1.TRANSACTION_ID,
T2.BANK_CARD_BANK_CODE,
T2.BANK_CARD_NUMBER,
T2.ATM_CARD_CAPTURE_REASON,
T2.ATM_PERIOD_NUMBER_ROUND,
T2.DID_CANCEL_LAST_TRANSACTION,
T2.CLEARING_PERIOD_FOR_CANCEL,
T2.TRANSACTION_ID_FOR_CANCEL,
T2.ATM_PERIOD_NUMBER_REC,
T2.ATM_CODE,
T2.ATM_TRANSACTION_CODE,
T2.TRANSACTION_TIMESTAMP,
T2.TRANSACTION_STATUS,
T2.APPLICATION_CODE_ERROR,
T1.ANOMALY_TYPE,
T1.ATM_ANOMALY_CODE,
T1.OPERATION_MOMENT,
T1.ATM_HARDWARE_ANOMALY,
T1.ATM_ERROR_TEXT,
T1.BANK_CARD_TRACK2_TLV,
T1.BANK_CARD_TRACK3_TLV,
T1.PRIM_ACC_NBR_PAN_TLV,
T1.APP_EXPIRATION_DATE_TLV,
T1.CHIP_PROC_RESULT_TLV,
T1.CLEARING_FLAG,
T1.CAPTURE_CARD_INDICATOR,
T1.CAPTURE_CARD_ID
From A007_T T1,
ATM_LOG T2
where T1.CLEARING_PERIOD = T2.CLEARING_PERIOD(+)
and T1.TRANSACTION_ID = T2.TRANSACTION_ID(+)
and T1.CLEARING_PERIOD >= 529
And T1.CLEARING_PERIOD <= 529
Order by CLEARING_PERIOD desc, TRANSACTION_ID desc