Advertisement
stevennathaniel

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

Mar 7th, 2016
284
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement