quote:

Database Results Error
Description: [Oracle][ODBC][Ora]ORA-00905: missing keyword
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers

quote:

SELECT PERSON_ALIAS.ALIAS AS MRN, PERSON.NAME_LAST_KEY AS LastName, PERSON.NAME_FIRST_KEY AS FirstName, CODE_VALUE_1.DISPLAY AS Status, CODE_VALUE.DISPLAY AS Store, ORDER_DISPENSE.RX_NBR AS RX, ORDERS.ORDER_MNEMONIC AS Orders, PRSNL.NAME_FULL_FORMATTED AS Prescriber, ORDER_DISPENSE.LAST_REFILL_DT_TM AS LastFilll, ORDER_DISPENSE.DAYS_SUPPLY AS DS, ORDER_DISPENSE.REFILLS_REMAINING AS RR, HEALTH_PLAN.PLAN_NAME AS HealthPlan, ORDERS.CURRENT_START_DT_TM AS DateWritten
FROM ((((((ORDERS INNER JOIN PERSON ON ORDERS.PERSON_ID = PERSON.PERSON_ID) INNER JOIN PERSON_ALIAS ON PERSON.PERSON_ID = PERSON_ALIAS.PERSON_ID) INNER JOIN ORDER_DISPENSE ON (ORDERS.ORDER_ID = ORDER_DISPENSE.ORDER_ID) AND (PERSON.PERSON_ID = ORDER_DISPENSE.PERSON_ID)) INNER JOIN CODE_VALUE ON ORDER_DISPENSE.RX_NBR_CD = CODE_VALUE.CODE_VALUE) INNER JOIN PRSNL ON ORDERS.LAST_UPDATE_PROVIDER_ID = PRSNL.PERSON_ID) INNER JOIN CODE_VALUE AS CODE_VALUE_1 ON ORDERS.ORDER_STATUS_CD = CODE_VALUE_1.CODE_VALUE) INNER JOIN HEALTH_PLAN ON ORDER_DISPENSE.HEALTH_PLAN_ID = HEALTH_PLAN.HEALTH_PLAN_ID
WHERE (((PERSON_ALIAS.ALIAS)=[ENTER MRN]) AND ((PERSON_ALIAS.ACTIVE_IND)=1))
ORDER BY ORDER_DISPENSE.LAST_REFILL_DT_TM DESC;