Bro, Itu error karena kurang field pt.patient_name. Kalo ada aggregasi di query harus ada group by yg mana isi nya semua field2 non aggregasi (jika menampilkan lbh dr 1 field) Kira2 gitu penjelasannya Thx
Regards, Febry Kurniawan Sent from my AXIS Worry Free BlackBerry® smartphone -----Original Message----- From: Gugun <[email protected]> Date: Tue, 2 Mar 2010 14:34:41 To: <[email protected]> Subject: [indo-oracle] Help Me Dear all Saya ada masalah nihh sayang ingin menjalankan query dibawah ini ,kenapa yahh selalu error SELECT DISTINCT (VST.PRN) AS NMR_MR, MAX(VST.REGISTRATION_DATE) AS LAST_VISIT, PT.PATIENT_NAME from NOVA_VISIT VST, NOVA_PATIENT PT where VST.PRN = PT.PRN AND REGISTRATION_DATE BETWEEN TO_DATE('01/01/2006','mm/dd/yyyy') AND TO_DATE('12/31/2009','mm/dd/yyyy') Group By VST.PRN makasihh sebelumnya regards -Gugun- New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
