SELECT T01_persons.PERS_LN, T01_persons.PERS_FN, T01_persons.PERS_MN,;
  T01_persons.PERS_BIRTH, H03_perspolicies.CONTRACT_ID,;
  H03_perspolicies.END_DATE, H03_perspolicies.INVAL_DATE,;
  T03_contracts.CONTR_STARTDATE, T03_contracts.CONTR_ENDDATE,;
  T02_orgs.RNUMBER, T02_orgs.RNUMBER15, T04_policies.POLICY_SERIES,;
  T04_policies.POLICY_NUMBER, H02_persaddresses.INVAL_DATE,;
  T02_orgs.INVAL_DATE, H01_persdocs.INVAL_DATE;
 FROM ;
     T01_PERSONS T01_persons ;
    left JOIN H02_PERSADDRESSES H02_persaddresses ;
   ON  T01_persons.ID_PERSON = H02_persaddresses.PERSON_ID ;
    left JOIN H01_PERSDOCS H01_persdocs ;
   ON  T01_persons.ID_PERSON = H01_persdocs.PERSON_ID ;
    left JOIN H03_PERSPOLICIES H03_perspolicies ;
   ON  T01_persons.ID_PERSON = H03_perspolicies.PERSON_ID ;
    left JOIN T03_CONTRACTS T03_contracts ;
   ON  H03_perspolicies.CONTRACT_ID = T03_contracts.ID_CONTRACT ;
    left JOIN T02_ORGS T02_orgs ;
   ON  T03_contracts.ORG_ID = T02_orgs.ID_ORG ;
    left JOIN T04_POLICIES T04_policies ;
   ON  H03_perspolicies.POLICY_ID = T04_policies.ID_POLICY;
 ORDER BY H03_perspolicies.END_DATE

CLEAR

CREATE CURSOR cMaster (f1 i, f2 c( 20 ))

CREATE CURSOR cdetails (f1 i, f2 c( 20 ))

INSERT INTO cMaster VALUES ( 1 , 'First record Master')
INSERT INTO cMaster VALUES ( 2 , 'Second record Master')

INSERT INTO cDetails VALUES ( 1 , 'First record Details')

SELECT * FROM cMaster cm INNER JOIN cDetails cd ON cm.f1 = cd.f1 INTO CURSOR cur
? 'Inner join'
LIST  
? 'Left join'
SELECT * FROM cMaster cm Left JOIN cDetails cd ON cm.f1 = cd.f1 INTO CURSOR cur
LIST 

SELECT * FROM cDetails cd Left JOIN cMaster cm ON cm.f1 = cd.f1 INTO CURSOR cur
LIST