Left Join

[qdivyact]

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]

-----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]

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?