Sorry saya tdk bisa tampilan semua field ( terlalu banyak ) ini field yang di butuhkan Table : TRN_REG
TRN_DATE TRN_TYPE TRN_DOC PROD_ID TRN_QTY PROD_UOM -------- -------- ------- ------- ------- -------- 3/10/2005 R1 1536 0020001 25 BTL 4/10/2005 SC 9632 0020001 5 BTL 5/10/2005 S1 4236 0020001 40 BTL dst Report saya ingin menampilkan pergerakkan per produk dalam suatu periode tertentu. Thanks --- In [email protected], Fernando Napitupulu <[EMAIL PROTECTED]> wrote: > > Bagaimana info mengenai tabel2 yg menghasilkan data > tsb, jika syntax yg dimaksud adl query? > > --- hyanamarta <[EMAIL PROTECTED]> wrote: > > Hi friends, > > > > Saya ingin membuat report seperti ini : > > > > Tgl Keterangan Masuk Keluar Saldo > > 1-10-2005 Saldo awal 100 0 100 > > 3-10-2005 Pembelian 25 0 125 > > 4-10-2005 Retur 5 0 130 > > 5-10-2005 Penjualan 0 40 90 > > dst...... > > > > Bagaimana syntax yang harus saya gunakan ? sekedar > > info saya > > menggunakan Database Oracle versi 8.1.7 > > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
