Re: [sqlalchemy] using WITH query AS, cte() with postgresql

[Michael Bayer]

On Sep 19, 2013, at 2:46 PM, Nathan Mailg <nathanma...@gmail.com> wrote:

> 
> c = aliased(City)
> q2 = s.query(q1).\
>        join(Appl.city).\
>        join(c, Appl.city).\
>        order_by(q1.c.lastname, q1.c.firstname)

why don't you join on the Column objects present rather than relying on the 
relationship?   

signature.asc
Description: Message signed with OpenPGP using GPGMail