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/
