Thanks guys, so i got it going with the hint to use an alias. Here is what i ended up getting to work... BUT*** i am not using the engine.execute.... does .all() work.. but its not recommended because im not having a problem whats the issue?
Here is what im doing. q3 = union(q1,q2).cte() q = q.join(q3, Account.id == q3.c.account_id) q.all() Why is q.all() working without a problem?? is it the cte() thats getting this working from the orm for me? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.