Re: Invalid Identifier #904

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
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

Original text of this message