#!/bin/bash
mysql -u root -psatriopiningit1924 keuangan_bpp<<EOFMYSQL
select a.no_trans, a.tgl_bukti, a.nis, b.nama, a.kelas, a.tahun_ajaran, a.kode_tagihan, a.jumlah, a.remark, a.created_by, a.created_date, a.updated_by, a.updated_date, a.akun_debet, a.akun_kredit from trans_tagihan a, siswa b
where a.nis=b.nis
order by b.nama, a.tgl_bukti;
EOFMYSQL