Re: [sqlalchemy] composite secondary join variant

2020-04-24 Thread Jonathan Vanasco
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 --

Re: [sqlalchemy] composite secondary join variant

2020-04-24 Thread Elmer de Looff
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