On Jan 23, 2008, at 10:25 AM, Alexandre Conrad wrote:
> model.Player.query.join(['site', 'playlists', 'hotlinks', > 'hotslot']).filter(model.SlotHot.c.id=='foo').all() > another thing im considering, along the lines of what I mentioned in http://groups.google.com/group/sqlalchemy/browse_thread/thread/6b5b1cda1b657723# , would look like this: query.join(['site', 'playlists', ('someprop', table.join(subtable)), MySubclass.someprop]) that is, "join to 'someprop' using this selectable as the target". which is the same thing as if the mapper has "select_table" on it in this case, but is a way to specify at the query level rather than the mapper level. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
