Re: [sqlalchemy] query with HAVING COUNT doesn't work as expected

Thanks! That solved it. I'm a JOIN newbie, so I didn't realize left join and outer join were the same thing. J. On Monday, August 3, 2015 at 5:08:44 PM UTC+2, Ladislav Lenart wrote: Hello. pgAdmin query uses LEFT JOIN whereas SQLAlchemy query uses (inner) JOIN. Replace .join(...)

[sqlalchemy] query with HAVING COUNT doesn't work as expected

I am using Python 2.7, SQLAlchemy 0.9.3, and PostgreSQL 9.4. This: session.query(self.db.recording_table.c.id).\ join(self.db.frame_table, self.db.recording_table.c.id == self.db.frame_table.c.recording_id).\ group_by(self.db.recording_table.c.id).\