Mike Conley wrote: > Here is what I did first > > q = session.query(Spec.SpecID,Spec.Spec_Name, > Rqmt.RqmtID,Rqmt.Rqmt_Name, > Rparam.RparamID,Rparam.Rparam_Name, > Rvalue.RvalueID,Rvalue.Rvalue_Name).\ > join(Rqmt,Rparam,Rvalue) > > SA complains about more than one foreign key constraint as expected
its query.join((dest, onclause)). so query.join((Rparam, Rvalue)) . more examples at http://www.sqlalchemy.org/docs/05/reference/orm/query.html?highlight=join#sqlalchemy.orm.query.Query.join . --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---