Invalid Identifier #904

From: jmarr02s <john.marruffo_at_illinois.gov>
Date: 29 Jan 2007 09:34:05 -0800
Message-ID: <1170092045.406517.20000_at_a34g2000cwb.googlegroups.com>



Hi,
[Quoted] Anyone have an idea what I am doing wrong? 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 Received on Mon Jan 29 2007 - 18:34:05 CET

Original text of this message