On Sep 3, 2008, at 6:06 PM, mg wrote:
> > So what I am understanding is that right now, SA only does LEFT OUTER > JOINS? Or am I misunderstanding? The "eager load" feature of a relation(), which is responsible for loading the child items on a collection, does only OUTER JOIN, since its assumed you want the parent object in all cases - eager loading has nothing to do with the selection of rows (i.e. the WHERE clause), only with populating an object graph more rapidly than would otherwise be the case. As I illustrated earlier, performing an INNER JOIN for the purposes of query criterion is straightforward. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---