>> >> How can I select user's addresses when I know only his id? And I don't >> want to select the user first. > > session.query(Address).join("user").select(User.c.id==<the user id>) > >
I was afraid of that :-) I hoped it can go in a cleaner way like join(Address.c.user) but giving the property as a string. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---