How to Select all possible distinct related "two-ways" values for any given ID from a junction table?

table TBL_IN "IN Document details table"

table TBL_OUT "OUT Document details table"

table TBL_INOUT "IN OUT Document Junction table"

Question is how to get the following query result in oracle sql or access query from the junction table?

query QRY_INOUT_Related "Select all possible related "two-ways" values for any given ID"

I hope I clarified the idea as possible as I can.

In Oracle, you appear to want a hierarchical query that finds all the distinct connections via either IID or OID and then want to aggregate:

SELECT id,
       LISTAGG(value, ',') WITHIN GROUP (ORDER BY value) AS io_related
FROM   (
  SELECT DISTINCT id, value
  FROM   (
    SELECT CONNECT_BY_ROOT oid AS id,
           iid,
           oid
    FROM   tbl_inout
    START WITH oid = 'O-20'
    CONNECT BY NOCYCLE
       PRIOR oid = oid
    OR PRIOR iid = iid
  )
  UNPIVOT(value FOR key IN (iid, oid))
  WHERE id <> value
)
GROUP BY id

Outputs:

ID	IO_RELATED
O-20	I-225,I-300,I-410,O-35

and

SELECT id,
       LISTAGG(value, ',') WITHIN GROUP (ORDER BY value) AS io_related
FROM   (
  SELECT DISTINCT id, value
  FROM   (
    SELECT CONNECT_BY_ROOT iid AS id,
           iid,
           oid
    FROM   tbl_inout
    START WITH iid = 'I-300'
    CONNECT BY NOCYCLE
       PRIOR oid = oid
    OR PRIOR iid = iid
  )
  UNPIVOT(value FOR key IN (iid, oid))
  WHERE id <> value
)
GROUP BY id

Outputs:

ID	IO_RELATED
I-300	I-225,I-410,O-20,O-35

db<>fiddle here