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