David Baird wrote: > > Okay, just built SQLite 3.5.9 and group_concat does in fact work: > > select group_concat(t, ' ') from w where f=1;
You forgot the parent value at the beginning. Also, the OP may want to do this for several parents which can be accomplished by grouping the results. select f || ' ' || group_concat(t, ' ') from w where f in (1, 2, 3); group by f; HTH Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users