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]
