SELECT

    tabtrans.TABTRANS_ID AS tabtrans_id
    ,tabtrans.TGL_TRANS AS tabtrans_tgl_trans
    ,TRIM(tabtrans.NO_REKENING) AS tabtrans_no_rekening
    ,TRIM(kodetranstabungan.KODE_TRANS) AS tabtrans_kode_trans
    ,TRIM(kodetranstabungan.DESKRIPSI_TRANS) AS tabtrans_deskripsi_trans
    ,tabtrans.SALDO_TRANS AS tabtrans_saldo_trans
    ,TRIM(tabtrans.MY_KODE_TRANS) AS tabtrans_my_kode_trans
    ,TRIM(tabtrans.KUITANSI) AS tabtrans_kuitansi
    ,TRIM(tabtrans.KETERANGAN) AS tabtrans_keterangan

FROM tabtrans
LEFT JOIN kodetranstabungan ON tabtrans.KODE_TRANS = kodetranstabungan.KODE_TRANS
