Join Tables

Kakay_Ranas — Sat, 16 Nov 2024 18:38:44 GMT

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)

)
;

Re: Join Tables

Brett_Bleess — Wed, 10 Jun 2020 13:43:11 GMT

This appears to be a straight SQL call, which is a little outside our scope. I would suspect any likely issues are a result of the driver/connector being used to the database source not being able to translate something in the query properly. Best I can offer, would suspect the better place to look for solutions would be on the DB/Connector vendor site rather than our forums in this case. Sorry I do not have a better answer for you.

Regards,
Brett

topic Re: Join Tables in QlikView

Join Tables

Re: Join Tables