OTBI Outer Join giving error
Content
Hi
I am getting an error when running the following SQl for an outer join. I need to pull all active employees and their rating. I need to show all actives so I need to do an outer join. However, I get an error.
Select BU, Cost_Center, Department, GL, Grade, Code, Level, Title, Number, Name, Rating
From
(
SELECT A.BU BU, A.Cost_Center Cost_Center, A.Department Department, A.GL GL, A.Grade Grade, A.Job_Code Code, A.Level Level, A.Title Title, A.Person_Number Number, A.Name Name, B.Rating Rating
from
(SELECT
"Compensation - Salary Details Real Time"."Business Unit"."Business Unit Name" BU,