Thanks! That works exactly as I needed. I knew there was a problem in the
secondaryjoin, so i commented it out.
This works more intuitively than my other composite relationships, which
are all more complex. The joining you used is:
primaryjoin: A->B
secondaryjoin: B->B2C
secondary: B2C->C
--
Hi Jonathan,
>From toying with it a little bit, it looks like you *need* to specify a
secondaryjoin when you specify the secondary table. In your example, the
secondary does some of the work that the secondaryjoin would need to do.
I've created a gist that mirrors your table setup (with some more
i'm stuck on a variant of the Composite Secondary Join (
https://docs.sqlalchemy.org/en/13/orm/join_conditions.html#composite-secondary-joins
)
I hope someone can see what my tired eyes are missing. I'm fairly certain
the issue is in `secondary' and 'secondaryjoin'. I've tried a handful of