SELECT t.no_referensi, t.tanggal, t.deskripsi, SUM(je.debit) as total_debit, SUM(je.kredit) as total_kredit, ABS(SUM(je.debit) - SUM(je.kredit)) as selisih FROM transaksi t JOIN detail_transaksi dt ON t.id = dt.transaksi_id JOIN jurnal_entry je ON dt.id = je.transaksi_detail_id GROUP BY t.id HAVING selisih