sidenote: there are typos. that's just to illustrate. i mostly copied that from production code.
the core concepts are: 1. `label()` the columns 2. use the `engine` (not orm) to join the queries 3. `alias` the union to search against them 4. the labeled columns in the earlier queries are now `.c.___` column attributes in the aliased query 5. you run the query in the `engine` ( not the orm ) -- 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.