SELECT A.REQ_PAY_ID, A.TYPE, B.REASON, B.PROCESS, B.AMT_PAY
FROM TR_REQ_ADVANCE_DT A
LEFT JOIN TR_REQ_PAY_PERIOD B ON A.REQ_PAY_ID = B.REQ_PAY_ID

where REF_ID = 'TRC000001125870' AND B.PROCESS IN('0', '2')