I think you may have to be more specific, perhaps by providing a sample schema, as your requirements are (to me at least) unclear.
Typically, a join table is used for many-to-many relations, and each row of the join table only references each of the joined tables once - I'm obviously not understanding something here.
I suspect that you may be looking for
computed columns[
^]