Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW v_data_pembayaran AS
- SELECT tbl_siswa.nis,
- tbl_siswa.nama_siswa,
- tbl_tagihan.nama_tagihan,
- tbl_tagihan.jumlah_tagihan,
- tbl_pembayaran.tgl_bayar
- FROM tbl_siswa
- LEFT JOIN tbl_pembayaran ON tbl_pembayaran.nis = tbl_siswa.nis
- LEFT JOIN tbl_tagihan ON tbl_tagihan.id_tagihan = tbl_pembayaran.id_tagihan
Advertisement
Add Comment
Please, Sign In to add comment
