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:
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