Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW v_invoice AS
- SELECT kwitansi.no_kwitansi ,kwitansi.tgl_kwitansi,
- kwitansi.nama_pelanggan ,kwitansi.alamat_pelanggan,detail_kwitansi.id_item,
- detail_kwitansi.kode_barang ,detail_kwitansi.nama_barang,detail_kwitansi.kuantitas,
- detail_kwitansi.harga_satuan,(detail_kwitansi.kuantitas * detail_kwitansi.harga_satuan) AS total_bayar
- FROM kwitansi
- JOIN detail_kwitansi ON detail_kwitansi.no_kwitansi = kwitansi.no_kwitansi
Advertisement
Add Comment
Please, Sign In to add comment
