whats the SQL output? where's it going wrong? unions and CTEs are both individually extremely complicated. putting them together is not surprising that it isn't working.
On Sep 25, 2014, at 6:42 PM, Jonathan Vanasco <[email protected]> wrote: > thanks to some testing, i realized that my previous attempt to select from a > union were wrong. i ended up selecting data from only one cte. > > given that I have a union like this: > > _unioned = sqlalchemy.union(query_Stream1, query_Stream2) > > how can I select data from the union? > > i've tried different variations of unioned.subquery(), unioned.cte(), > select(unioned), etc. i either generate an error or only generate sql that > corresponds to the left-handed select. > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
