On 2015-10-09 12:22 AM, K. P. wrote: > I tried this, of course, before asking, but: > group_concat(distinct(t.LastName || ', ' || t.FirstName), '; ') As Teachers, > gives > [15:19:32] Error while executing SQL query on database 'test': DISTINCT > aggregates must have exactly one argument
As the error suggests, it can't have more than one argument (parameter), so this should work: group_concat(distinct (t.LastName || ', ' || t.FirstName || '; ')) As Teachers,