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!

Constants normally go inside sigle quotes not double quotes. If that is not your specific problem then take the error message at its word and compare your column names to the table describes.

HTH -- Mark D Powell -- Received on Thu Jul 24 2003 - 22:57:08 CEST