Re: ORA-00904: invalid column name

A few thoughts spring to mind for me.

You didn't give your table definitions. The error simply means that one fo the column names provided does not excist in the table referenced. We can't, form what you've told us so far, determine whether or not you simply have not mis-spelt a column name. I suggets you check.

Also, is it a new 9i-ism that I've missed to date? What is "now()"? I can guess. try substituting references to "now()" for "SYSDATE". See if that helps.

Also, change your double quotes around the search string to single quotes.

One other quick comment. You have a series of GROUP BY expressions yet aren't using any aggreageting fuctions. As far as I know, this will just have the effect of sorting the result set. Better to use ORDER BY to be more correct.

"Shino" <lwc7_at_hotmail.com> wrote in message news:8f16856.0307231954.565584d6_at_posting.google.com...
> Hi,
>
> Can anyone help with this error: "ORA-00904: invalid column name"?
> Thanks!
>
> SQL> create view PPFa as
> 2 SELECT L.UserID AS LecID, U.Name, U.Email, I.IntakeID, S.UserID
> AS StudID
> 3 FROM User_Lecturer L, User_Student S, TBL_Intake I, Users U
> 4 WHERE L.UserID=S.InitialSupervisorID And L.UserID=U.UserID And
> S.PPFState="PPF Not approved yet
> " And S.bIsActive=True And S.txtIntakeID=I.IntakeID And
> Dateadd('d',S.PPF_ExtraDays,I.PPF_Lock)<now(
> ) And I.CompletionDate>now()
> 5 GROUP BY L.UserID, U.Name, U.Email, I.IntakeID, S.UserID
> 6 ;
> WHERE L.UserID=S.InitialSupervisorID And L.UserID=U.UserID And
> S.PPFState="PPF Not approved yet" And
>
> ERROR at line 4:
> ORA-00904: invalid column name
>
>
> Thank you and have a nice day!
Received on Thu Jul 24 2003 - 10:17:08 CEST