I've been through the docs but I can't quite work this out - seems quite simple though.
I just want to do an aliased join, for the purposes of ordering by it, using the following SQL: LEFT OUTER JOIN things AS things_2 ON ( objects.id = things_2.object_id AND things_2.name = 'test' ) I've tried the following but it doesn't like it: query.join(aliased, Object.things, and_(aliased.object_id == Object.id, aliased.name == 'test')) I get the error: Object '<sqlalchemy.sql.expression.ClauseList object at 0xa46dfec>' is not a Selectable and does not implement `__selectable__()` --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---