Re: Query divides movie titles into different columns

[Luigi Chiabrera]

good morning Peter,
I think it can be fine


SELECT
a.actor_id actId,
a.act_img actImg,
group_concat(DISTINCT f1.title ORDER BY f1.film_id) title
FROM
(select film_id,actor_id
from film_actor where actor_id = 1) fa1 inner join film f1 ON fa1.film_id = f1.Film_id
inner join actor a ON fa1.actor_id = a.actor_id


--- result


actId actImg title

1 l_blair.jpg Exorcist-I,Exorcist-II