tag:blogger.com,1999:blog-5101583409018752071.post2049182713582699777..comments2023-10-30T02:50:29.438-07:00Comments on Library Accounting Department: Tempat Kumpul Tugas Review MSQL 3AD4Library Accounting Departmenthttp://www.blogger.com/profile/16809122000099124737noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5101583409018752071.post-64708455282715905832011-10-17T21:11:54.510-07:002011-10-17T21:11:54.510-07:00Nama : Ismi Sri Wahyuni
NIM : 461 09 023
nomor 1
...Nama : Ismi Sri Wahyuni<br />NIM : 461 09 023<br /><br />nomor 1<br />SELECT BARANG.KODEBARANG, NAMABARANG, PERSEDIAANAWAL, HARGAJUAL<br />FROM Barang;<br />Nomor2<br />SELECT Mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, keterangan<br />FROM mastertransaksi;<br />Nomor 3<br />SELECT Detailtransaksi.ID, NOTRANS, KODEBARANG, UNIT, HARGA<br />FROM DETAILTRANSAKSI;<br />Nomor 4<br />SELECT barang.kodebarang, namabarang, detailtransaksi.notrans, unit, harga<br />FROM BARANG INNER JOIN DETAILTRANSAKSI ON BARANG.KODEBARANG = DETAILTRANSAKSI.KODEBARANG;<br />Nomor 5<br />SELECT mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, keterangan<br />FROM mastertransaksi;<br />Nomor 6<br />SELECT mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, detailtransaksi.kodebarang, unit, harga<br />FROM DETAILTRANSAKSI INNER JOIN MASTERTRANSAKSI ON DETAILTRANSAKSI.NOTRANS = MASTERTRANSAKSI.NOTRANS;<br />Nomor 7<br />SELECT barang.namabarang, detailtransaksi.notrans, unit, harga, (detailtransaksi.unit * (barang.hargajual)) AS jumlahstandar, (detailtransaksi.unit * harga) AS jumlahrealisasi<br />FROM BARANG INNER JOIN DETAILTRANSAKSI ON BARANG.KODEBARANG = DETAILTRANSAKSI.KODEBARANG;<br />Nomor 8<br />SELECT detailtransaksi.ID, notrans, kodebarang, unit, harga<br />FROM detailtransaksi<br />WHERE ((detailtransaksi.notrans)="TR001");<br />Nomor 9<br />SELECT detailtransaksi.ID, notrans, kodebarang, unit, harga<br />FROM detailtransaksi<br />WHERE ((detailtransaksi.kodebarang)="B001");<br />Nomor 10<br />SELECT mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, keterangan, detailtransaksi.unit, harga, (detailtransaksi.unit * harga ) AS jumlah<br />FROM DETAILTRANSAKSI INNER JOIN MASTERTRANSAKSI ON DETAILTRANSAKSI.NOTRANS = MASTERTRANSAKSI.NOTRANS<br />WHERE ((detailtransaksi.kodebarang)="B009");Anonymoushttps://www.blogger.com/profile/11694456011595560432noreply@blogger.comtag:blogger.com,1999:blog-5101583409018752071.post-33011131727254930532011-10-17T18:23:30.954-07:002011-10-17T18:23:30.954-07:00Nama : Dwitya Saadah Suaib
NIM : 46109001
Nomor 1
...Nama : Dwitya Saadah Suaib<br />NIM : 46109001<br />Nomor 1<br />SELECT BARANG.KODEBARANG, NAMABARANG, PERSEDIAANAWAL, HARGAJUAL<br />FROM Barang;<br />Nomor2<br />SELECT Mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, keterangan<br />FROM mastertransaksi;<br />Nomor 3<br />SELECT Detailtransaksi.ID, NOTRANS, KODEBARANG, UNIT, HARGA<br />FROM DETAILTRANSAKSI;<br />Nomor 4<br />SELECT barang.kodebarang, namabarang, detailtransaksi.notrans, unit, harga<br />FROM BARANG INNER JOIN DETAILTRANSAKSI ON BARANG.KODEBARANG = DETAILTRANSAKSI.KODEBARANG;<br />Nomor 5<br />SELECT mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, keterangan<br />FROM mastertransaksi;<br />Nomor 6<br />SELECT mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, detailtransaksi.kodebarang, unit, harga<br />FROM DETAILTRANSAKSI INNER JOIN MASTERTRANSAKSI ON DETAILTRANSAKSI.NOTRANS = MASTERTRANSAKSI.NOTRANS;<br />Nomor 7<br />SELECT barang.namabarang, detailtransaksi.notrans, unit, harga, (detailtransaksi.unit * (barang.hargajual)) AS jumlahstandar, (detailtransaksi.unit * harga) AS jumlahrealisasi<br />FROM BARANG INNER JOIN DETAILTRANSAKSI ON BARANG.KODEBARANG = DETAILTRANSAKSI.KODEBARANG;<br />Nomor 8<br />SELECT detailtransaksi.ID, notrans, kodebarang, unit, harga<br />FROM detailtransaksi<br />WHERE ((detailtransaksi.notrans)="TR001");<br />Nomor 9<br />SELECT detailtransaksi.ID, notrans, kodebarang, unit, harga<br />FROM detailtransaksi<br />WHERE ((detailtransaksi.kodebarang)="B001");<br />Nomor 10<br />SELECT mastertransaksi.notrans, tanggaltransaksi, jenistransaksi, keterangan, detailtransaksi.unit, harga, (detailtransaksi.unit * harga ) AS jumlah<br />FROM DETAILTRANSAKSI INNER JOIN MASTERTRANSAKSI ON DETAILTRANSAKSI.NOTRANS = MASTERTRANSAKSI.NOTRANS<br />WHERE ((detailtransaksi.kodebarang)="B009");Anonymousnoreply@blogger.com