[sqlalchemy] Re: Different results with select and object using outerjoin

2008-01-24 Thread MattQc
Thank you for the answer! Does it have any performance differences between the 3 manners? Which one could be the fastest if I have a lot of nested joins to do with other tables? Thanks On Jan 23, 4:30 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jan 23, 2008, at 3:28 PM, MattQc wrote:

[sqlalchemy] Re: Different results with select and object using outerjoin

2008-01-24 Thread Michael Bayer
On Jan 24, 2008, at 11:36 AM, MattQc wrote: Thank you for the answer! Does it have any performance differences between the 3 manners? Which one could be the fastest if I have a lot of nested joins to do with other tables? straight SQL constructs without using the ORM are always much

[sqlalchemy] Re: Different results with select and object using outerjoin

2008-01-23 Thread Michael Bayer
On Jan 23, 2008, at 3:28 PM, MattQc wrote: Object query returns an empty set: In 3: jLane = tblspotbandsol.outerjoin(tbllane, tbllane.c.laneid==tblspotbandsol.c.laneid) In 4: mapper(LaneClass,jLane) Out4: sqlalchemy.orm.mapper.Mapper object at 0xb36f382c In 5: