On Oct 9, 10:57 am, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> the debug prints out the inner select statement non-nested in the
> outer statement, so you get the full list of from clauses. the
> func.count(shiptag_table.c.shipid) on the outer query sticks
> shiptag_table in the outer FROM, thus removing it from the inner query
> due to auto-correlation. you probably mean to say
> func.count(inner_q.c.shipid) instead so that the outer is selecting
> from the subquery, not the shiptag_table by itself (but then I see a
> lot of other references to shiptag_table there, so its not really
> clear what statement you're going for...).
>
>
Yeah, this was exactly what was happening,
I turned off the auto-correlation for the inner_q and got the desired
output SQL and results.
Thanks Michael
Thanks,
Wayne
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---