Query that works in SQL Developer gives error ORA-00998 on column tp.job when I try and create a vie
The following query works when I run it, yet when I try and create a View I get the error ORA-00998. I have tried aliasing the column t.job, with no success. I've read documentation, and still don't understand what I need to do to create this view. Any insights would be most appreciated.
Select T.Job ,(Select Name From Gl_Companymastr C Where C.Company=(Select Company From Jc_Headermaster H Where H.Job=T.Job)) As Company_Name,T.Ticket_Number,T.Ticket_Date,T.Time,T.Customer,
(Select Name From Ar_Customermast Cm Where Cm.Company=(Select Company From Jc_Headermaster H Where H.Job=T.Job) And Cm.Customer=T.Customer) As Customer_Name,Nvl(T.Customer_Job,' ') Customer_Job,
Select T.Job ,(Select Name From Gl_Companymastr C Where C.Company=(Select Company From Jc_Headermaster H Where H.Job=T.Job)) As Company_Name,T.Ticket_Number,T.Ticket_Date,T.Time,T.Customer,
(Select Name From Ar_Customermast Cm Where Cm.Company=(Select Company From Jc_Headermaster H Where H.Job=T.Job) And Cm.Customer=T.Customer) As Customer_Name,Nvl(T.Customer_Job,' ') Customer_Job,
0