is there a way to concatenate the results of a string field like the way sum(field) is used when grouping?
e.g. I want to do something like this...
select c.country, sum(y.city_pop)
from country c
join city y on c.id = y.cid
group by country
with strings....
e.g.
select c.country, **CONCAT*** (y.city) //some concatenation possible
from country c
join city y on c.id = y.cid
group by country
Start Free Trial
