How to link hz_cust_account_roles table and hz_parties table

Hi Team,

Actually i have to display the person first name and person last name.

we have 7 levels so i have to display person first name and person last name for 7 levels.

In the hz_cust_account_roles table, you will find columns called 'attributes1 to 'attributes6' where the party ID is being stored.

while joining the attributes the data not populate.

Please let me know

SELECT
    hr1.*
FROM
    (
        SELECT
            hr.*
        FROM
            hz_relationships  hr,
            hz_parties        hp
        WHERE
                hr.party_id = hp.party_id
            AND hp.party_id = 20086805
    )                  a,
    hz_parties    hr1
WHERE
    a.subject_id = hr1.party_id;