> John Found <johnfo...@asm32.info>: > > The following code does not work, but gives an idea what I want to do: > > create table t (a, b); > > select > group_concat(b) as list > from t > group by a > having ?1 in (list);
> > Clemens Ladisch <clem...@ladisch.de> : > > select > group_concat(b) as list > from t > where a in (select a > from t > where b = ?1) > group by a; I think the original query is the best, here the having clause is be written as valid sql. select group_concat(b) as list from t group by a having count(b=?1) ; _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users