Hello,
I'm trying to join tables, I'm getting all the result I need except for as COM_Supervisor_Name in the query below. Can you advise what I'm doing wrong?
SELECT *
FROM OPERATIONS_SANDBOX.WSM_COMMUNITY_SCHEDULE a
LEFT JOIN OPERATIONS_SANDBOX.OA_ADP_WORKER_MASTER adp
ON TRIM(UPPER(a.AGENT_EMAIL)) = TRIM(UPPER(adp.EMAIL))
AND adp.EXPIRATION_DATE IS NULL
ORDER BY SOW_DATE
;
Select Email as Supervisor, (adp.First_Name || ' ' || adp.Last_Name) as COM_Supervisor_Name
From OPERATIONS_SANDBOX.OA_ADP_WORKER_MASTER adp
Where adp.ASSOCIATE_ID in (
Select adp.ReportsTo_ID
From OPERATIONS_SANDBOX.OA_ADP_WORKER_MASTER adp
Where adp.OpsJobCode in (1,2,3,4,5,6,7,8,9,13,15)
)
;
.png "Former Employee"){kind=icon}
