Re: [sqlalchemy] Aliased table in subsequent join and select statement does not work?

2016-08-18 Thread Rogier Eggers
I was confused as some of the SQLA functions I used here are from Core (e.g. in the whereclause) and was therefore focussing on Core. But indeed aliased work much better (and make sense because of the mapped classes) Thanks! On Thu, Aug 18, 2016 at 6:26 PM, Mike Bayer wrote: > > > On 08/18/

Re: [sqlalchemy] Aliased table in subsequent join and select statement does not work?

2016-08-18 Thread Mike Bayer
On 08/18/2016 11:41 AM, Rogier Eggers wrote: I am wondering whether I use the incorrect functions in sqlalchemy or if I'm possibly just going the complete wrong way about this. I have two Tables, "Tests" and "Signals", which are related through a many-to-many relationship (technically it could

[sqlalchemy] Aliased table in subsequent join and select statement does not work?

2016-08-18 Thread Rogier Eggers
I am wondering whether I use the incorrect functions in sqlalchemy or if I'm possibly just going the complete wrong way about this. I have two Tables, "Tests" and "Signals", which are related through a many-to-many relationship (technically it could be one-to-many, but that decision has been ma