On Feb 3, 2014, at 10:11 PM, big stone <stonebi...@gmail.com> wrote:
> bag colors bag1 blue - red - yellow bag2 green - yellow Does that really require a recursive query? Wouldn’t a simple group by + group_concat do as well? with DataSet as ( select 'bag1' as bag, 'blue' as color union all select 'bag1' as bag, 'red' as color union all select 'bag1' as bag, 'yellow' as color union all select 'bag2' as bag, 'green' as color union all select 'bag2' as bag, 'yellow' as color ) select DataSet.bag as bag, group_concat( DataSet.color, ' - ' ) as colors from DataSet group by DataSet.bag order by DataSet.bag; P.S. I’m starting to develop a strong aversion to that ‘values( … )’ syntax… sigh... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users