[sqlalchemy] Joins: Returning multiple instances, and a potential bug

2010-10-31 Thread Michael Elsdörfer
I'm sorry if this is an obvious question, but there seem to be a couple ways to do joins, and I seem unable to find an example explaining how to achieve my particular result. I need to join two tables, and I want the mapper objects of both tables returned. Essentially, I want

Re: [sqlalchemy] Joins: Returning multiple instances, and a potential bug

2010-10-31 Thread Michael Bayer
On Oct 31, 2010, at 3:43 AM, Michael Elsdörfer wrote: session.query(m1, m2) but of course, that doesn't do an actual join, and I need to use filter() instead of an onclause. While in this particular case I don't really care, I would imagine that there probably are scenarios where one