Hi,
>foo = session.query(MainTable).filter_by(customer='CUSTNAME')
>foo = foo.filter(ChildTable.c.othercolumn.in_('bar', 'baz', 'qux'))
>
>
You need to do the join; pass the name of the relation (not the target
table) to join:
foo = foo.join('childtable').filter(ChildTable.c.othercolumn.in_('bar', 'baz',
'qux'))
Paul
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
