Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
-----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 ?
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?