SHARE
TWEET

MS ACCESS : SQL Inner Join Multiple Table ( lebih dari 2 )

stevennathaniel Mar 7th, 2016 76 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT datapembelian.idpembelian, datapelanggan.namapelanggan, databarang.namabarang, dataprodusen.namaperusahaan, datapembelian.jumlahitem, datapembelian.hargaperitem, datapembelian.jumlahhargaitem FROM ((datapembelian
  2. INNER JOIN datapelanggan ON datapembelian.idpelanggan = datapelanggan.idpelanggan)
  3. INNER JOIN databarang ON datapembelian.idbarang = databarang.idbarang)
  4. INNER JOIN  dataprodusen ON datapembelian.idprodusen = dataprodusen.idprodusen
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top