Query that works in SQL Developer gives error ORA-00998 on column tp.job when I try and create a vie
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,