Advertisement
Guest User

Untitled

a guest
Dec 9th, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. select supplier.nama_supplier, pasok.tanggal_pasok,pasok.jumlah_pasok from supplier join pasok on supplier.kode_supplier=pasok.kode_supplier;
  2.  
  3. NAMA_SUPPLIER TANGGAL_P JUMLAH_PASOK
  4. ------------------------------ --------- ------------
  5. JOJO 19-OCT-19 5
  6. RIFKI 20-OCT-19 10
  7. FEISAL 21-OCT-19 5
  8. JODY 22-OCT-19 10
  9. DAIM 23-OCT-19 5
  10.  
  11. SQL> Select barang.nama_barang, supplier.nama_supplier, pasok.tanggal_pasok, pasok.jumlah_pasok
  12. 2 from supplier join pasok on supplier.kode_supplier = pasok.kode_supplier
  13. 3 join barang on barang.kode_barang = pasok.kode_barang;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement