On Mon, Jun 9, 2008 at 11:40 AM, Dennis Cote <[EMAIL PROTECTED]> wrote: > 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;
Ahh, right. Thanks for fixing that :-) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users