如何制作这样的查询报告？

Question

I just want make query report like this but always fail when going to angsuran_ke =3 can't change value query saldo total pinjaman please help me

IMAGE REPORT

IMAGE CODE

SELECT tb_nasabah.id_nasabah
     , tb_nasabah.nama
     , tb_angsuran.angsuran_ke
     , tb_angsuran.tgl_angsur
     , if(tb_angsuran.angsuran_ke > 1 && angsuran_ke <= 10,
          (tb_pinjaman.besar_pinjaman_sekarang - tb_angsuran.besar_angsuran), besar_pinjaman_sekarang) as total
     , tb_angsuran.besar_angsuran,besar_pinjaman_sekarang
FROM tb_nasabah,
     tb_pinjaman,
     tb_angsuran
where tb_nasabah.id_nasabah = tb_pinjaman.id_anggota
  and tb_nasabah.id_nasabah = tb_angsuran.id_nasabah