Caros,
Tava aqui recuperando uns endereços para uma integração e cheguei até uma query que relaciona tudo.

SELECT *
FROM   CUSTTABLE
       INNER JOIN DIRPARTYTABLE
       ON     CUSTTABLE.PARTYID    = DIRPARTYTABLE.PARTYID
       AND    CUSTTABLE.DATAAREAID = DIRPARTYTABLE.DATAAREAID
       INNER JOIN DIRPARTYADDRESSRELATIONSHIP
       ON     DIRPARTYTABLE.PARTYID    = DIRPARTYADDRESSRELATIONSHIP.PARTYID
       AND    DIRPARTYTABLE.DATAAREAID = DIRPARTYADDRESSRELATIONSHIP.DATAAREAID
       INNER JOIN DIRPARTYADDRESSRELATIONSHI1066
       ON     DIRPARTYADDRESSRELATIONSHIP.RECID      = DIRPARTYADDRESSRELATIONSHI1066.PARTYADDRESSRELATIONSHIPRECID
       AND    DIRPARTYADDRESSRELATIONSHIP.DATAAREAID = DIRPARTYADDRESSRELATIONSHI1066.DATAAREAID
       INNER JOIN ADDRESS
       ON     DIRPARTYADDRESSRELATIONSHI1066.REFCOMPANYID = ADDRESS.DATAAREAID
       AND    DIRPARTYADDRESSRELATIONSHI1066.ADDRESSRECID = ADDRESS.RECID
       AND    DIRPARTYADDRESSRELATIONSHI1066.DATAAREAID   = ADDRESS.DATAAREAID

[]s
Pichler