ORA-00904: invalid column name
Date: 23 Jul 2003 20:54:52 -0700
Message-ID: <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 - 05:54:52 CEST