How to map records relationship to an SQL View's outer join properly

Hey Appian Community Team,

I am currently trying to map v22.3 relationship properly to an outer join that is SQL based query which is a view itself.

Fundamentally im talking about inner and outer join to map for e.g. PID to REF PID. I was thinking of source filter but it will probably face limitations as well.

An extract of the code is listed below

(SELECT
      A.REF_PROPOSAL_ID,
      LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CODE END, ', ') WITHIN GROUP (ORDER BY CATG.CODE) CATEGORY_CODE,
      LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CATEGORY END, ', ') WITHIN GROUP (ORDER BY CATG.CATEGORY) CATEGORY
      FROM ABC_PROPOSAL_CATEGORIES A
      INNER JOIN ABC_PROPOSALS P ON A.PID = A.REF_PROPOSAL_ID
      INNER JOIN ABC_CATEGORIES CATG ON B.PID = A.REF_CATEGORY_ID
      GROUP BY A.REF_PROPOSAL_ID
      ) B,