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: 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. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---