Oracle Passthrough Query via MS Access - From keywork not found

[IngDep]

Assistance needed to determine the issue with Oracle pass-through query via MS Access.

Error received is ORA 00923 - From keyword not found where expected.

Thanks in advance.

SELECT MEMBER.MEME_LAST_NAME
, MEMBER.MEME_FIRST_NAME
, MEMBER.MEME_BIRTH_DT
, MEMBER.MEME_MEDCD_NO
, MEMBER.MEME_CCC_START_DT
, MEMBER.MEME_CCC_END_DT
, PROV.PRPR_NAME
, Min(CLAIM.CLCL_LOW_SVC_DT) AS AdmitDate
, Max(CLAIM.CLCL_HIGH_SVC_DT) AS DischDate
, HOSP.AGRG_ID AS FinalDRG
, HOSP.CLHP_INPUT_AGRG_ID AS InputDRG
, CLAIM.CLCL_ID
, SUM(CLAIM.CLCL_TOT_CHG) > 1000
, CLAIM.TOT_PAYABLE

, BASE.UMSV_AUTH_DT
, BASE.UMSV_FROM_DT
, BASE.UMSV_TO_DT
, BASE.UMSV_PRE_AUTH_PROC
, BASE.UMSV_PRE_AUTH_PROV

FROM MEMBER
INNER JOIN SUBSCRIBER.SBSB_CK = MEMBER.SBSB_CK

INNER JOIN PROV
ON MEMBER.MEME_CK = PROV.MEME_CK

INNER JOIN PRPR_PROV.PRPR_ID
ON PROV.PRPR_ID = PRPR_PROV.PRPR_ID

INNER JOIN CL_LINE
ON MEMBER.MEME_CK = CL_LINE.MEME_CK

INNER JOIN CLAIM
ON CL_LINE.CLCL_ID = CLAIM.CLCL_ID
AND PRPR_PROV.PRPR_ID = CLAIM.PRPR_ID

INNER JOIN HOSP
ON CL_LINE.CLCL_ID = HOSP.CLCL_ID

INNER JOIN BASE
ON MEMBER.MEME_CK = BASE.MEME_CK

INNER JOIN SUBSCRIBER
ON MEMBER.SBSB_CK = SUBSCRIBER.SBSB_CK
AND CLASS.GRGR_CK = SUBSCRIBER.GRGR_CK

WHERE MEMBER.MEME_LAST_NAME Like 'SMITH'


GROUP BY

MEMBER.MEME_LAST_NAME
, MEMBER.MEME_FIRST_NAME
, MEMBER.MEME_BIRTH_DT
, MEMBER.MEME_MEDCD_NO
, MEMBER.MEME_CCC_START_DT
, MEMBER.MEME_CCC_END_DT
, PROV.PRPR_NAME
, Min(CLAIM.CLCL_LOW_SVC_DT)
, Max(CLAIM.CLCL_HIGH_SVC_DT)
, HOSP.AGRG_ID AS FinalDRG
, HOSP.CLHP_INPUT_AGRG_ID
, CLAIM.CLCL_ID
, CLAIM.CLCL_TOT_CHG
, CLAIM.TOT_PAYABLE
, BASE.UMSV_AUTH_DT
, BASE.UMSV_FROM_DT
, BASE.UMSV_TO_DT
, BASE.UMSV_PRE_AUTH_PROC
, BASE.UMSV_PRE_AUTH_PROV;

 

[jimirvine]

Your problem is here

, SUM(CLAIM.CLCL_TOT_CHG) > 1000

invalid syntax in a SELECT clause. Also, why include aggregates in you group by clause?