Re: [sqlalchemy] Translating a sql union statement into SA problem

2010-01-28 Thread werner
Michael, On 27/01/2010 19:37, Michael Bayer wrote: werner wrote: q2 = session.query(stAlias2).outerjoin((stAlias2, stAlias2.code_id==stAlias3.code_id), this is going to render select * fromalias2 left outer joinalias2 on alias2.code_id==alias3.code_id i.e. rendersalias2 twice

[sqlalchemy] Translating a sql union statement into SA problem

2010-01-27 Thread werner
I am trying different solutions to my problem of getting default languages back. I have following statement: Select T1.id, T1.code_id, T1.lang_code5, T1.name from somecode_t T1 where T1.lang_code5 = 'FR_fr' UNION Select T2.id, T2.code_id, T2.lang_code5, T2.name from somecode_t T2 left outer