> hanya record no 5, 6, 7 dan 8. Tampaknya row ke 8 tglnya bulan JUNI bukan JULI!?
Apakah ada "TANDA" bagi suatu record untuk dinyatakan sbg outstanding (sebagai lawan dari closed), atau hanya kriteria bulan? -------- Anggap bulan aktif 07-2005; jadi filter pertama WHERE bulan 07-2005 kemudian filter kedua AND yang outstanding hg meskipun transaksinya bulan 07-2005 kalau sudah tidak outstanding, rownya tidak dimasukkan sbg result set. jadi querynya kira-kira SELECT... WHERE bulan 07-2005 AND yang outstanding .... ferry sends. ----- Original Message ----- From: "m4z3" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, October 18, 2005 9:29 AM Subject: [indo-oracle] Cari record outstanding > Hi rekan2, > Saya mempunyai view union dr bbrp tabel yg isi recordnya spt dibawah: > > VENDOR_NO DATED ORDER_NO REL_NO SEQ_NO LIN_NO PART_NO TRAN_CODE IDR_PRICE DIRECTION Qty > IV0032 05/01/05 10256 1 1 1 A1 ARR-NONINV 46696212 + 2 > IV0032 28/02/05 10256 1 1 1 A1 SUPPPAY 46696212 - 2 > IV0032 05/01/05 10256 2 1 1 B5 ARR-NONINV 61859919.15 + 3 > IV0032 28/02/05 10256 2 1 1 B5 SUPPPAY 61859919.15 - 3 > IV0032 15/07/05 11213 1 1 1 R0 ARR-NONINV 61859919.15 + 1 > IV0032 30/07/05 11213 1 1 1 R0 SUPPPAY 61859919.15 - 1 > IV0032 30/07/05 21551 1 1 1 F1 ARR-NONINV 61859919.15 + 5 > IV0032 08/06/05 11111 1 1 1 F1 ARR-NONINV 61859919.15 + 8 > > saya ingin menghasilkan report misalkan > di bulan Juli 2005 (per akhir bulan) yg muncul > hanya record2 yg outstanding saja dan record2 yg tgl > transaksinya di bulan bersangkutan (Juli 2005), jd yg muncul > hanya record no 5, 6, 7 dan 8. > > Mungkin rekan2 bisa memberikan masukan mengenai > sintak sql atau pl/sql utk menghasil record2 > yg diingikan dg waktu eksekusi yg minimum. > > -- > m4z3 ------------------------ 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/
