HumanaGeek
July 26th, 2005, 10:00 AM
Everyone,
End of the rope is growing shorter...time is running out, and I can't seem to understand (let alone solve) this problem:
I get the error message: "missing right parenthesis" with the following code:
(SELECT COUNT(CL_CALL_LOGGING.CALL_NUMBER), AR_CLIENT_COMPANY.CLIENT_CO_NAME
FROM
CL_CALL_LOGGING, AR_CLIENT_COMPANY
WHERE
CL_CALL_LOGGING.PARTITION = 6 AND
CL_CALL_LOGGING.CLIENT_COMPANY_REF = AR_CLIENT_COMPANY.CLIENT_CO_REF AND
AR_CLIENT_COMPANY.CLIENT_CO_NAME IS NOT NULL
GROUP BY
AR_CLIENT_COMPANY.CLIENT_CO_NAME
ORDER BY
1)
Any assistance anyone might be able to provide would be greatly appreciated!
Kyle
End of the rope is growing shorter...time is running out, and I can't seem to understand (let alone solve) this problem:
I get the error message: "missing right parenthesis" with the following code:
(SELECT COUNT(CL_CALL_LOGGING.CALL_NUMBER), AR_CLIENT_COMPANY.CLIENT_CO_NAME
FROM
CL_CALL_LOGGING, AR_CLIENT_COMPANY
WHERE
CL_CALL_LOGGING.PARTITION = 6 AND
CL_CALL_LOGGING.CLIENT_COMPANY_REF = AR_CLIENT_COMPANY.CLIENT_CO_REF AND
AR_CLIENT_COMPANY.CLIENT_CO_NAME IS NOT NULL
GROUP BY
AR_CLIENT_COMPANY.CLIENT_CO_NAME
ORDER BY
1)
Any assistance anyone might be able to provide would be greatly appreciated!
Kyle