Re: Query divides movie titles into different columns

[Luigi Chiabrera]

I tried this query but it returns the id instead of the titles.

select actor_id, group_concat(distinct film_id order by film_id asc separator ' ')
from film_actor
group by actor_id

Also how can I combine it with the original query?
I imagine you are abusing your patience, but please don't
I am very familiar with mysql