I have a pass-thru query that is pulling data from a data warehouse using sql. I'm trying to add a table (KP_EXTL_CASE) using a left join but not sure how to integrate that into the existing code framework that declares each table as a letter and where each table is linked via a where statement. I want to label KP_EXTL_CASE as "L". Please see attached. Thanks!
FROM HPEPP20.PS_KP_DW_ISU A,
HPEPP20.PS_KP_DW_ISU_CTGRY B,
HPEPP20.PS_KP_DW_LVL_CTGRY C,
HPEPP20.PS_KP_DW_PRVDR_GRP D,
HPEPP20.PS_KP_DW_DEPT_ORG F,
HPEPP20.PS_KP_DW_TM_PER I,
HPEPP20.PS_KP_DW_MBR_INFO E,
HPEPP20.PS_KP_DW_FAC_ORG G,
HPEPP20.PS_KP_DW_PRVDR H,
HPEPP20.PS_KP_ISU_DESCR J,
HPEPP20.PS_KP_DW_MBR_CTGRY K,
LEFT JOIN HPEPP20.PS_KP_EXTL_CASE L ON A.CASE_ID = L.CASE_ID
WHERE B.KP_ISSU_CTGRY_IK = A.KP_ISSU_CTGRY_IK
AND C.KP_LVL_CTGRY_IK = A.KP_LVL_CTGRY_IK
AND K.KP_MBR_CTGRY_IK = A.KP_MBR_CTGRY_IK
AND D.KP_PRVDR_GRP_IK = A.KP_PRVDR_GRP_IK