ALTER SESSION SET TIME_ZONE = ' +04:00 '; SELECT css . id AS credit_subs_id, -- EVENT.CREDIT_SUBS_ID css . customer_id AS customer_id, -- EVENT.CUSTOMER_ID css . subs_date , csl . id AS service_id, csl . name AS device_name, csl . credit_status , csl . auto_payable , csl . counter FROM SUBSCRIPTION . CREDIT_SRV_SUBS css JOIN SUBSCRIPTION . CREDIT_SRV_LIST csl ON css . service_id = csl . id WHERE csl . credit_status = ' a ' AND csl . auto_payable IN ( 1 , 4 ) AND ROWNUM <= 20 ORDER BY css . id DESC ; ========================================================================== SELECT customer_id, tmcode, billcycle, cscurbalance, prev_balance, passportno, cssocialsecno, birthdate, ...