view_cicil

create view tampil_cicil as select a.no_cicilan, b.no_pinjam, c.no, c.nam
a, c.alamat, c.tgl_lahir, b.jumlah as jumlah_pinjam, b.lama as lama_pinjam, b.angsuran as besar_cici
lan, b.tgl as tanggal_pinjam from cicilan a inner join pinjam b on a.no_pinjam = b.no_pinjam inner j
oin anggota c on b.no_anggota = c.no;