benar pak yudi, harus pake logika OR. ferry sends.
----- Original Message ----- From: "Addino Yudi Abdal" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, October 19, 2005 4:33 PM Subject: Re: [indo-oracle] Cari record outstanding > > ----- Original Message ----- > From: "Ferry" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, October 19, 2005 2:33 AM > Subject: Re: [indo-oracle] Cari record outstanding > > > > > 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 > > mungkin pake OR.... pak > > > > .... > > > > 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 --------------------~--> 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/
