how about q = session.query(D) q.select(q.join_via(["address", "country"]) & (Country.c.name == 'france'))
or q = SelectResults(session.query(D)) q.join_to("address").join_to("country").select(Country.c.name=='france') im not down with shoving literal strings into **kwargs at all.... --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---