Re: Invalid Identifier #904
Date: 29 Jan 2007 11:35:23 -0800
Message-ID: <1170099322.891234.279930_at_m58g2000cwm.googlegroups.com>
On Jan 29, 8:34 pm, "jmarr02s" <john.marru..._at_illinois.gov> wrote:
> Hi,
> 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
Wild guess: wrong table referenced. Does LOOKUPVALUES table really has RECVDATE column, or does it belong to CINTAKE? If the latter, change B.RECVDATE to A.RECVDATE and things should be fine.
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Mon Jan 29 2007 - 20:35:23 CET