I am trying to construct a subquery for use in a join with sqlite that does something like:
SELECT group_concat(b.name, '|') FROM table_b b JOIN table_d d ON d.b_id=b.id WHERE d.col=12 I adapted a post at https://groups.google.com/forum/#!topic/sqlalchemy/9iSkwxFAJjY but I am not sure how to integrate this with a query such as: query = session.query(B.name).\ join(D).\ filter(D.table_b_id == B.id).\ filter(D.col == some_val).\ all() Ultimately, I want to use this subquery as select for an additional column in a larger join. Thanks! jlc -- 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.