PRAKTIKUM 5
TUGAS PENDAHULUAN
1.
Query
1.
Perintah SQL:
a.
SELECT
ORDER.NOMER_ORDER, ORDER.TANGGAL_ORDER, BARANG.NAMA_BRG
FROM ([ORDER] INNER JOIN (BARANG INNER JOIN DETAIL_ORDER ON BARANG.NOMER_BRG
= DETAIL_ORDER.NOMER_BRG) ON ORDER.NOMER_ORDER = DETAIL_ORDER.NOMER_ORDER)
INNER JOIN PELANGGAN ON ORDER.NOMER_PLG = PELANGGAN.NOMER_PLG;
b.
SELECT
ORDER.NOMER_ORDER, BARANG.NOMER_BRG, BARANG.HARGA
FROM ([ORDER] INNER JOIN (BARANG INNER JOIN DETAIL_ORDER ON
BARANG.NOMER_BRG = DETAIL_ORDER.NOMER_BRG) ON ORDER.NOMER_ORDER =
DETAIL_ORDER.NOMER_ORDER) INNER JOIN PELANGGAN ON ORDER.NOMER_PLG =
PELANGGAN.NOMER_PLG
WHERE (((BARANG.HARGA)>1500));
c.
SELECT
ORDER.NOMER_ORDER, PELANGGAN.NAMA_PLG, ORDER.TANGGAL_ORDER
FROM ([ORDER] INNER JOIN (BARANG INNER JOIN DETAIL_ORDER ON
BARANG.NOMER_BRG = DETAIL_ORDER.NOMER_BRG) ON ORDER.NOMER_ORDER =
DETAIL_ORDER.NOMER_ORDER) INNER JOIN PELANGGAN ON ORDER.NOMER_PLG =
PELANGGAN.NOMER_PLG
WHERE (((ORDER.TANGGAL_ORDER)>#1/21/1999#));
d.
SELECT
ORDER.NOMER_ORDER, PELANGGAN.NOMER_PLG, BARANG.NAMA_BRG
FROM ([ORDER] INNER JOIN (BARANG INNER JOIN DETAIL_ORDER ON
BARANG.NOMER_BRG = DETAIL_ORDER.NOMER_BRG) ON ORDER.NOMER_ORDER =
DETAIL_ORDER.NOMER_ORDER) INNER JOIN PELANGGAN ON ORDER.NOMER_PLG =
PELANGGAN.NOMER_PLG;
Tidak ada komentar:
Posting Komentar