On 11 Sep., 22:12, Conor <conor.edward.da...@gmail.com> wrote: > This query will get you close to your desired SQL: > q = session.query(ATable) > q = q.filter( > sa.exists( > [1], > ((BTable.atable_id == ATable.id) > & (CTable.cval.in_(["foo", "bar"]))), > from_obj=orm.join(BTable, CTable)))
Great! Works like a charm! Thank you! seppo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
