groupby nya kurang PT.PATIENT_NAME,
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, PT.PATIENT_NAME
Gugun wrote:
>
>
> 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-
>
>
>
