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,