Re: [sqlalchemy] Many-to-many using custom join columns and autoloaded tables

2020-07-22 Thread Rob Rosenfeld
Thanks. Sorry I missed that. I latched onto "*Joins to a Target Entity or Selectable*" On Tue, Jul 21, 2020 at 11:15 PM Mike Bayer wrote: > to join on the relationships you have to name them: > > > Class.query.join(Class.enrollments).join(Enrollment.students).join(Student.details) > > the

Re: [sqlalchemy] Many-to-many using custom join columns and autoloaded tables

2020-07-21 Thread Mike Bayer
to join on the relationships you have to name them: Class.query.join(Class.enrollments).join(Enrollment.students).join(Student.details) the different ways to join are laid out at https://docs.sqlalchemy.org/en/13/orm/query.html?highlight=query%20join#sqlalchemy.orm.query.Query.join On Tue,