mungkin di grouping-nya. Group By VST.PRN
padahal nggak ada column output query yg bernama VST.PRN.
coba group by NMR_MR. karena VST.PRN di select sebagai NMR_MR.
On 3/2/2010 1:34 PM, 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-
>
>
>
>
>
>
>
>
>
> 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]
>
>
>
