Hey Experts,
I am new to SQL Programming .
I am trying to process a query in BIRT Tool, when processing am getting below mentioned error.
ERROR : ORA-0417:a table may be outer joined to at most one other table
1. I am trying to fetch Employee Manager first name & Last Name using self join( PA_STUDENT S ,PA_STUDENT M )
( i ) When i am trying to place a separator in First Name & Last Name am getting error.
CONCAT(S.LNAME, ' , ' ,S.FNAME) as Name_Last_First_Middle
2. Using join am fetching JOB Location details (PA_JOB_LOC J )
3. Now am getting error when i tried/added to pulling data from this table - PA_CPNT_EVTHST C
SQL QUERY
SELECT s.stud_id as P_Unique_Key,
CONCAT(S.LNAME ,S.FNAME) as Name_Last_First_Middle,
S.HIRE_DTE as Hire_Date,
J.JL_ID,
S.JOB_TITLE as Title,
CONCAT(M.LNAME, M.FNAME) as MMName,
C.CPNT_TYP_ID,
C.CPNT_ID,
C.CPNT_DESC,
C.COMPL_DTE
FROM
PA_STUDENT S,
PA_JOB_LOC J,
PA_STUDENT M,
PA_CPNT_EVTHST C
WHERE S.JL_ID(+) = J.JL_ID
AND S.STUD_ID(+) = C.STUD_ID
AND S.SUPER = M.STUD_ID
Regards,
KR.