Hello, I need help with SQL query joining 3 subject areas — 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

Hello, I need help with SQL query joining 3 subject areas

edited Aug 13, 2025 2:29AM in Performance Management

Summary:

Hi, I need some help to verify my query. I'm trying to join 3 subject areas: "Workforce Profiles - Person Profile Real Time", "Workforce Performance - Performance Rating Real Time" and "Workforce Profiles - Model Profile Real Time"

I'm trying to fetch these data. I want to show the required and actual competency as rated by employee and manager.

Thank you so much in advance!

A.EmployeeName,
A.UnionName,
A.Union
A.Division,
A.Department,
A.Branch,
A.Position,
B.PerformanceDocument,
B.ReviewPeriod,
B.CompetencyName,
B.ActualProficiency,
B.ProficiencyDescription,
B.Role,
B.ParticipantName,
C.RequiredProficiency

(SELECT
"Workforce Profiles - Person Profile Real Time"."Department"."Department Name" Department,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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