You should be able to concatenate the first and last name in a subquery and then use group_concat to output the single column you describe.
For example: select group_concat(clientname, ';') from (select FirstName || ',' || LastName from yourtable); On Thu, Oct 8, 2015 at 4:54 PM, K. P. <platysternon at hotmail.com> wrote: > 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 > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
