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 :-( . > this will disable the uniquing logic used for a single class and > return tuples containining instances of the above three classes, > exactly corresponding to the full result of the outerjoin. Primary > keys which aren't fulfilled for the joined classes will correspoind to > an object value of None. > I got what I call a work around.
I keep the Firebird view and to a outerjoin on it. Gives me the result I want but I can not get rid of the view - not a big deal. 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 -~----------~----~----~----~------~----~------~--~---