Thanks for that.I'd need something along the lines of group_concat(c.LastName || ', ' || c.FirstName, ';') as ClientName,
which in itself does not seem to be supported. c.LastName || ', ' || c.FirstName, ';') as FullName, group_concat(FullName, ';') as ClientName, also not.... :( Any way around this? > From: slavins at bigfraud.org > Date: Thu, 8 Oct 2015 17:01:06 +0100 > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] Can this be done in SQLite? > > > On 8 Oct 2015, at 4:59pm, K. P. <platysternon at hotmail.com> wrote: > > > Given the following tables, is it possible to extract rows of class data > > along with all participating student names concatenated in one column in a > > single SQL query? > > See the 'group_concat()' function: > > <https://www.sqlite.org/lang_aggfunc.html> > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
