if you wrote your above statement directly in SQL, and you reference an outer table in a subquery without putting the table in the subquery's FROM clause (which looks similar to the way a select() in SQLAlcehmy looks), the subquery would also be correlating. so this default is largely based on the "visual" effect of the expression as well as that multi-refs to the same table are typically accomplished using aliases.
we could say that, if you put a table in an explicit FROM clause (using from_obj), then dont correlate that table. but this behavior might just be more confusing, since its an implicit "guessing" style of behavior (that correlate=True by default is not as much of a guess). it would grant the ability to pick and choose which tables correlate, though. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
