Thanks for the clarification. I'm suddenly getting no results at all when I add this filter, but at least now I know I'm doing the syntax right. Never a dull moment. :)
On 3/14/16, Jonathan Vanasco <jonat...@findmeon.com> wrote: > >> >> .filter(t1.c1=='hello', and_(t3.c1=='world')) >> > > The and_ Is wrong in this context. Everything in `filter` is joined by > "and" by default. You just want: > > .filter(t1.c1=='hello', t3.c1=='world') > > `and_` is usually used in a nested condition, often under an `or_`. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.