Invalid Identifier (#904)

[jmarr02s]

Hi,
Anyone have an idea what I am doing wrong? I am using MS Access and I
am creating a Pass Through Query. I get the following error:

ODBC--call failed>
[Oracle][ODBC][Ora]ORA-00904; "B"."RECVDATE": invalid identifier
(#904)

Here is my code:

SELECT A.CMPSRC, 1 AS COUNTVALUE, B.VALDESC
FROM MDSDBA.CINTAKE A,
MDSDBA.LOOKUPVALUES B
WHERE
A.INTAKEID=B.ID
AND B.RECVDATE>=to_date( '01-09-2005','dd-mm-yyyy')
AND B.RECVDATE<=to_date( '30-09-2005','dd-mm-yyyy')
AND A.CMPSRC IS NOT NULL
GROUP BY
A.CMPSRC;

Thanks in advance!

John

[Baz]

The error is coming from Oracle not Access, but at a guess I would say that
B.RECVDATE is an invalid identifier (presumably doesn't exist in table
MDSBA.LOOKUPVALUES).

For more in-depth help with Oracle queries you need to be in an Oracle
forum.

"jmarr02s" <jo***********@illinois.govwrote in message
news:11*********************@j27g2000cwj.googlegro ups.com...

Hi,
Anyone have an idea what I am doing wrong? I am using MS Access and I
am creating a Pass Through Query. I get the following error:

ODBC--call failed>
[Oracle][ODBC][Ora]ORA-00904; "B"."RECVDATE": invalid identifier
(#904)

Here is my code:

SELECT A.CMPSRC, 1 AS COUNTVALUE, B.VALDESC
FROM MDSDBA.CINTAKE A,
MDSDBA.LOOKUPVALUES B
WHERE
A.INTAKEID=B.ID
AND B.RECVDATE>=to_date( '01-09-2005','dd-mm-yyyy')
AND B.RECVDATE<=to_date( '30-09-2005','dd-mm-yyyy')
AND A.CMPSRC IS NOT NULL
GROUP BY
A.CMPSRC;

Thanks in advance!

John