Michael, Michael Bayer wrote: > ... > OK, more specifically, this is how to do the query: > > sess.query(SomeClass, SomeOtherClass, > SomeThirdClass).outerjoin((SomeOtherClass, > SomeClass.foo==SomeOtherClass.bar), (SomeThirdClass, > SomeOtherClass.foo==SomeThirdClass.bar)) > > if firebird can't do OUTER JOIN, then that's a different story. > That did the trick and is also a lot faster then using the view which is even better.
Actually it was a little simplar as SA figured out the onclause, i.e.: wines = session.query(db.Cellarbook, db.Cbvintage, db.Cbbottle).outerjoin(db.Cbvintage).outerjoin(db.Cbbottle) Thanks for being patient with me Werner --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---