Seeing Both Sides of a Self-Join

[mdfOffman]

I have a table Doc with Documents stored with their titles.     I link Docs to other Docs showing their relationship, e.g. Doc 2 is supplemental to Doc 1.  I do this with a Join table DocLinks with 4 fields: fkDoc1, Relation 1, fkDoc2, Relation 2.  The latter 2 fields are linked to the table Doc 2.

I want to be able to see that relationship in the portal when I view Doc 2 in the main Doc Layout without having a separate portal.

How do I achieve in Filemaker the equivalent of this SQL Statement?

SELECT fkDoc1, Relation 1, fkDoc2 AS fkDoc1, Relation2 AS Relation1

Thanks for anyone's help 🙂

[comment]

I am afraid my SQL skills are insufficient to understand what exactly you're after. Seems very similar to another question of yours, though:

https://fmforums.com/topic/109483-double-sided-join

 

[mdfOffman]

You are right.  It is the same question.  I was hoping that, if I explained it more clearly, a light bulb might go off for somebody!!

[comment]

42 minutes ago, mdfOffman said:

I was hoping that, if I explained it more clearly, a light bulb might go off for somebody!!

That's quite possible - but I don't think you have met your own condition...