Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select supplier.nama_supplier, pasok.tanggal_pasok,pasok.jumlah_pasok from supplier join pasok on supplier.kode_supplier=pasok.kode_supplier;
- NAMA_SUPPLIER TANGGAL_P JUMLAH_PASOK
- ------------------------------ --------- ------------
- JOJO 19-OCT-19 5
- RIFKI 20-OCT-19 10
- FEISAL 21-OCT-19 5
- JODY 22-OCT-19 10
- DAIM 23-OCT-19 5
- SQL> Select barang.nama_barang, supplier.nama_supplier, pasok.tanggal_pasok, pasok.jumlah_pasok
- 2 from supplier join pasok on supplier.kode_supplier = pasok.kode_supplier
- 3 join barang on barang.kode_barang = pasok.kode_barang;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement