On 8 Oct 2015, at 9:54pm, 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. Why not ? What is the complete SELECT command ? What happens when you try it ? If it really isn't valid ... Create a VIEW which returns the individual concatenations. Then use group_concat() in a SELECT on the VIEW. Simon.
