Re: ORA-00904: invalid column name

lwc7_at_hotmail.com (Shino) 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!

String literals are enclosed by ' not by " Please consult the documentation before asking such basic questions

Sybrand Bakker
Senior Oracle DBA Received on Thu Jul 24 2003 - 21:44:13 CEST