Hi,
Michael Bayer написа: > SA can form joins between tables automatically if the tables express > the proper foreign key relationship between each other, and if there is > no ambiguity in that relationship; i.e. table A and table B have only > one ForeignKeyConstraint (or single ForeignKey) between each other. > > if you have table A and table B, a join is just: My questions was about the case when you have more then 2 tables (A->B->C->D) related, is this possible too? > > A.join(B) > > with regards to integrating those joins with mapper queries, see > http://www.sqlalchemy.org/docs/datamapping.myt#datamapping_selectrelations_queryjoins > . the main keyword argument to select() here is the "from_obj" > parameter. regards, StefanB --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---