Terima kasih pak ..., saya semangat sekali sampai teler-teler tiap malam lho.
Masih ijo/beginner hehe lom tau teknik penggabungan, mana yang pakai inner join, queter join Thanks. handoko -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of murdi santoso Sent: Wednesday, September 07, 2005 12:56 PM To: [email protected] Subject: Re: [indo-oracle] Lanjutan Posisi stock semoga membantu... belajar lebih giat untuk querynya... jangan mudah menyerah dalam mencari solusi...OK SELECT a.KODE_BRG,a.NAMA_BRG,masuk,keluar,harga FROM barang a, (SELECT b.KODE_BRG,NVL(SUM(b.QTY),0) masuk,NVL(SUM(c.QTY_FIFO),0) keluar, b.HARGA FROM pemasukan b,pemakaian c WHERE b.KODE_BRG=c.KODE_BRG(+) AND b.HARGA=c.HARGA_FIFO(+) GROUP BY b.KODE_BRG,b.HARGA) d WHERE a.KODE_BRG=d.KODE_BRG(+) --- Handoko <[EMAIL PROTECTED]> wrote: > > > > Terima kasih atas respon dari rekan-rekan , tapi ada > yang kurang.....!!! > > Tanya lagi boleh ya...? lanjutan stock kemarin, > kalau mau memampilkan data > seperti table di bawah ini querynya gimana...? > > 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-003 MEJA 5 0 2000 > A-004 KURSI 10 0 3000 > A-005 SEPEDA 5 5 5000 > A-005 SEPEDA 10 7 10000 > > > > 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 > > Terima Kasih > Handoko > > > > > [Non-text portions of this message have been > removed] > > __________________________________________________ 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 --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
