I am trying to do an left outer join from two sql queries but cannot
find
how to join on multiple columns.
I am using the outerjoin function.
The only way I found was to use a text clause for the on clause.
Basically, I have:
q1 = create_sql1().alias('qleft')
q2 = create_sql2().alias('qright')
oj = outerjoin(q1,q2,text('(qleft.a,qleft.b)=(qright.a,qright.b)'))I am using a postgresql database. Is there another way to do it to avoid the text clause? Thanks, Arno --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
