> 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
Can you explain that? What's the || ' ' || part? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
