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 [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/groups/opt_out.
