OTBI Outer Join giving error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Outer Join giving error

edited Oct 21, 2019 8:23PM in Reporting and Analytics for HCM 7 comments

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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!