[sqlalchemy] Re: joining/aliasing problems

2010-07-12 Thread Daniel
One last question, is it possible to do a full outer join? Thanks, Daniel On Jul 11, 5:24 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 11, 2010, at 5:40 AM, Daniel wrote: I've managed to fix it using sqalchemy.orm.outerjoin in conjunction with query's select_from function.

Re: [sqlalchemy] Re: joining/aliasing problems

2010-07-12 Thread Michael Bayer
you'd have to use unions, or a custom SQL construct if your database happens to support the actual FULL OUTER JOIN syntax. On Jul 12, 2010, at 9:26 AM, Daniel wrote: One last question, is it possible to do a full outer join? Thanks, Daniel On Jul 11, 5:24 pm, Michael Bayer

[sqlalchemy] Re: joining/aliasing problems

2010-07-11 Thread Daniel
I've managed to fix it using sqalchemy.orm.outerjoin in conjunction with query's select_from function. Out of interest, why is the naming scheme different for these 2 functions? which two names/functions are you referring to ? outerjoin and select_from, one seems to be lower case, the

Re: [sqlalchemy] Re: joining/aliasing problems

2010-07-11 Thread Michael Bayer
On Jul 11, 2010, at 5:40 AM, Daniel wrote: I've managed to fix it using sqalchemy.orm.outerjoin in conjunction with query's select_from function. Out of interest, why is the naming scheme different for these 2 functions? which two names/functions are you referring to ? outerjoin and