[sqlalchemy] Re: Query variable outerjoin()

2009-01-08 Thread ml
this is what I'm looking for but it doesn't work in 0.4.8. 0.5 is fine? Michael Bayer napsal(a): do you perhaps mean to say, query(Sortment).outerjoin((Translation, and_(Sortiment.id==Translation.sortiment_id, Translation.langauge=='en'))) ? On Jan 7, 2009, at 4:04 PM, ml wrote:

[sqlalchemy] Re: Query variable outerjoin()

2009-01-08 Thread Michael Bayer
its an 0.5 paradigm. in 0.4 you do the more manual practice of selecting from joins you create with the expression language: query(X).select_from( table1.outerjoin(table2, and_(table1.c.foo==table2.c.bar, table2.c.x=='y')) ) On Jan 8, 2009, at 3:41 AM, ml wrote: this is what I'm

[sqlalchemy] Re: Query variable outerjoin()

2009-01-07 Thread ml
That is a solution but it is not very efficient. It involves a sequential scanning of the result of the join inside the database. Michael Bayer napsal(a): On Jan 7, 2009, at 11:49 AM, ml wrote: Hi! I have 2 tables: sortiment(id, ...) translations(id, id_sortiment, language,