SELECT

    kretrans.KRETRANS_ID AS kretrans_id
    ,kretrans.TGL_TRANS AS kretrans_tgl_trans
    ,kretrans.NO_REKENING AS kretrans_no_rekening
    ,kretrans.MY_KODE_TRANS AS kretrans_my_kode_trans
    ,kodetranskredit.KODE_TRANS AS kretrans_kode_trans
    ,kodetranskredit.DESKRIPSI_TRANS AS kretrans_deskripsi_trans
    ,kretrans.transkol AS kretrans_transkol
    ,kretrans.KUITANSI AS kretrans_keterangan
    ,kretrans.POKOK_TRANS AS kretrans_pokok_trans
    ,kretrans.BUNGA_TRANS AS kretrans_bunga_trans
    ,kretrans.ADMIN_TRANS AS kretrans_admin_trans
    ,kretrans.DENDA_TRANS AS kretrans_denda_trans
    ,kretrans.DISC_POKOK AS kretrans_disc_pokok
    ,kretrans.DISC_BUNGA AS kretrans_disc_bunga
    ,kretrans.ZAKAT_TRANS AS kretrans_zakat_trans
    ,kretrans.POKOK_TRANS + kretrans.BUNGA_TRANS + kretrans.ADMIN_TRANS + kretrans.DENDA_TRANS AS kretrans_total_angsuran
    ,kretrans.TransBakiDebet AS kretrans_transbakidebet
    ,kretrans.TransSisaBunga AS kretrans_transsisabunga
    ,kretrans.PELUNASAN AS kretrans_flag_pelunasan

FROM kretrans
LEFT JOIN kodetranskredit ON kretrans.KODE_TRANS = kodetranskredit.KODE_TRANS
WHERE kretrans.MY_KODE_TRANS NOT LIKE '2%'
ORDER BY kretrans.KRETRANS_ID