topic Re: Left Join in QlikView

Left Join

qdivyact — Mon, 11 Mar 2019 12:07:30 GMT

I have three tables PROGRAM, REGION, PROVIDER
I want all records from PROGRAM, so joined as shown below

PROGRAM:
LOAD
PROG_ID,
PROG_NAME,
REGION ID
FROM PROG.qvd

LEFT JOIN(PROGRAM)

REGION:
LOAD
REGION ID,
REGION_NAME,
REGION CODE
FROM REGION.qvd

Now i want the same to be done with PROVIDER

PROVIDER:
LOAD
PROV_ID,
PROV_NAME,
PROV_DESC,
PROV_DATE,
REGION ID
FROM PROV.qvd

LEFT JOIN(PROVIDER)

REGION:
LOAD
REGION ID,
REGION_NAME,
REGION CODE
FROM REGION.qvd

How can i join REGION again with PROVIDER ?

qdivyact — Mon, 11 Mar 2019 12:29:17 GMT

-----Updated-----

I have three tables PROGRAM, REGION, PROVIDER
I want all records from PROGRAM, so joined as shown below

PROGRAM:
LOAD
PROG_ID,
PROG_NAME,
REGION ID
FROM PROG.qvd

LEFT JOIN(PROGRAM)

REGION:
LOAD
REGION ID,
AREA_ID,
REGION_NAME,
REGION CODE
FROM REGION.qvd

Now i want the same to be done with PROVIDER

PROVIDER:
LOAD
PROV_ID,
PROV_NAME,
PROV_DESC,
PROV_DATE,
AREA_ID
FROM PROV.qvd

LEFT JOIN(PROVIDER)

REGION:
LOAD
REGION ID,
AREA_ID,
REGION_NAME,
REGION CODE
FROM REGION.qvd

How can i join REGION again with PROVIDER ?

dplr-rn — Mon, 11 Mar 2019 13:01:22 GMT

Not 100% sure what the issue is. in the case mentioned it will join but based on AREA_ID

Can you elaborate what the issue you are facing? are you getting an error?