Re: [sqlalchemy] Missing table in FROM clause in generated subquery

2018-08-15 Thread kevin
I was missing the correlate(). Thanks a lot Mike! Best regards, Kevin On 16/08/2561 00:26, Mike Bayer wrote: On Tue, Aug 14, 2018 at 12:40 AM, wrote: Dear SQLAlchemy experts, I'm having difficulty generating an SQL query with SQLAlchemy. I'm trying to query a list of messages with their o

Re: [sqlalchemy] Missing table in FROM clause in generated subquery

2018-08-15 Thread Mike Bayer
On Tue, Aug 14, 2018 at 12:40 AM, wrote: > Dear SQLAlchemy experts, > > I'm having difficulty generating an SQL query with SQLAlchemy. > > I'm trying to query a list of messages with their originator and recipients. > Each message is sent by one host to one or more hosts. Hosts are all stored > i

[sqlalchemy] Missing table in FROM clause in generated subquery

2018-08-13 Thread kevin . thierry . citlao
Dear SQLAlchemy experts, I'm having difficulty generating an SQL query with SQLAlchemy. I'm trying to query a list of messages with their originator and recipients. Each message is sent by one host to one or more hosts. Hosts are all stored in one table (host). There are two types of messages s