You wrap your two conditions with and_() as your onclause. Mariano Mara wrote: > Hi everyone, > how do I use two clauses in an outerjoin? > e.g.: select ... from t1 outer join t2 on (t1.c1=t2.c1 and > t1.c2<t2.c2) > > According to docs, outerjoin is > outerjoin(left, right, onclause=None) > so I don't really know where to place the second clause. > In a query object, outerjoin is different: > outerjoin(*props, **kwargs) although I couldn't find much > documentation about it. > > TIA, > Mariano. > > > > >
-- David Gardner Pipeline Tools Programmer Jim Henson Creature Shop dgard...@creatureshop.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---