On Sep 12, 2008, at 1:09 PM, Werner F. Bruhin wrote:
> > Michael Bayer wrote: >> On Sep 12, 2008, at 12:49 PM, Werner F. Bruhin wrote: >> >> >>> Michael Bayer wrote: >>> ... >>> >>>> Now, if you actually want to get back objects for the outerjoins, >>>> youd >>>> say somehting like: >>>> >>>> sess.query(SomeClass, SomeOtherClass, SomeThirdClass) >>>> >>>> >>> On Firebird when I do this I get a "cross join" (according to the >>> Helen >>> Borrie book) which in my case gives me 280 rows instead of the 8 :- >>> ( . >>> >> >> what is the SQL being emitted ? 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. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---