Re: Query divides movie titles into different columns

[Luigi Chiabrera]

The query performs right

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

because the table 'film_actor' is structured like this:

CREATE TABLE `film_actor` (
`actor_id` smallint(5) UNSIGNED NOT NULL,
`film_id` smallint(5) UNSIGNED NOT NULL,
`role` varchar(50) NOT NULL,
`last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

the 'title' column is in the 'film' table

confused!!!