Michael Bayer wrote:
try using the flag "correlate=False" in the Select which you want to be fully self-contained.
Unfortunately, I need it to be correlated (it is relative to the current daily date), it just needs its own FROM statement.
(also post the full code, since I think using the alias for the "yearly" table should be working also)
Ok, I'll try and extract a self-contained working example (as it is part of complex query builder where the user can pick and choose various business criteria that eventually resolve to constructed SA queries).
Robert ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
