Emmmh... manjur Pak murdi querynya Terima kasih atas bantuannya.
Handoko -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of murdi santoso Sent: Tuesday, September 06, 2005 2:19 PM To: [email protected] Subject: Re: [indo-oracle] Query Posisi Stock semoga membantu..... SELECT A.KODE_BRG,A.NAMA_BRG,B.MASUK,c.keluar,B.HARGA FROM BARANG A, (SELECT B1.KODE_BRG,SUM(B1.QTY) AS MASUK,B1.HARGA FROM BARANG A1, PEMASUKAN B1 WHERE A1.KODE_BRG=B1.KODE_BRG GROUP BY B1.KODE_BRG,B1.QTY,B1.HARGA) B, (SELECT B2.KODE_brg, SUM(qty_fifo) AS keluar, HARGA_FIFO FROM barang a2, pemakaian b2 WHERE a2.kode_brg=b2.kode_brg GROUP BY b2.kode_brg,HARGA_FIFO) c WHERE A.KODE_BRG=B.KODE_BRG AND a.kode_brg=c.kode_brg AND B.HARGA=C.HARGA_FIFO --- Handoko <[EMAIL PROTECTED]> wrote: > Dear All.. > Saya lagi kebingungan...:-( membuat query posisi > stock...!! > > Berikut ini adalah table-table yang saya gunakan > > Table Barang : > > KODE_BRG > NAMA_BRG > > A-001 > SANDAL > > A-002 > SEPATU > > A-003 > MEJA > > A-004 > KURSI > > A-005 > SEPEDA > > Table Barang_masuk > > NO_BUKTI > TANGGAL > KODE_BRG > QTY > HARGA > > 123 > 9/6/2005 > A-002 > 10 > 1500 > > 123 > 9/6/2005 > A-003 > 5 > 2000 > > 123 > 9/6/2005 > A-005 > 5 > 5000 > > 123 > 9/6/2005 > A-004 > 10 > 3000 > > 12345 > 9/7/2005 > A-005 > 10 > 10000 > > 123 > 9/6/2005 > A-001 > 10 > 1000 > > Table Barang Keluar > > NO_BUKTI > KODE_BRG > TANGGAL_FIFO > QTY_FIFO > HARGA_FIFO > > O-001 > A-005 > 9/6/2005 > 3 > 5000 > > O-001 > A-001 > 9/6/2005 > 5 > 1000 > > O-001 > A-002 > 9/6/2005 > 4 > 1500 > > O-002 > A-005 > 9/8/2005 > 1 > 5000 > > O-003 > A-005 > 9/6/2005 > 1 > 5000 > > O-003 > A-005 > 9/7/2005 > 7 > 10000 > > Saya telah mencoba dengan menggunakan single query > seperti dibawah ini : > > SELECT > A.KODE_BRG,A.NAMA_BRG,B.MASUK,c.keluar,B.HARGA FROM > BARANG A, > (SELECT B1.KODE_BRG,SUM(B1.QTY) AS MASUK,B1.HARGA > FROM > BARANG A1, PEMASUKAN B1 > WHERE A1.KODE_BRG=B1.KODE_BRG > GROUP BY B1.KODE_BRG,B1.QTY,B1.HARGA) B, > (SELECT B2.KODE_brg, sum(qty_fifo) as keluar > from > barang a2, pemakaian b2 > where > a2.kode_brg=b2.kode_brg > group by b2.kode_brg) c > WHERE A.KODE_BRG=B.KODE_BRG > and a.kode_brg=c.kode_brg > > Hasilnya tidak sesuai dengan keingianan saya, > hasilnya sbb > > KODE_BRG > NAMA_BRG > MASUK > KELUAR > HARGA > > A-001 > SANDAL > 10 > 5 > 1000 > > A-002 > SEPATU > 10 > 4 > 1500 > > A-005 > SEPEDA > 5 > 12 > 5000 > > A-005 > SEPEDA > 10 > 12 > 10000 > > Yang saya kasih tanda bold pada posisi keluar > merupakan qty yang salah..!, > > Hasil Query yang saya inginkan adalah Sbb > > KODE_BRG > NAMA_BRG > MASUK > KELUAR > HARGA > > A-001 > SANDAL > 10 > 5 > 1000 > > A-002 > SEPATU > 10 > 4 > 1500 > > A-005 > SEPEDA > 5 > 5 > 5000 > > A-005 > SEPEDA > 10 > 7 > 10000 > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
