Re: Query divides movie titles into different columns

[Peter Brawley]

You're flailing, slow down, take a breath.

The query you just posted has multiple problems.

We build complex queries, based on a statement of requirement, from simpler components. The query you posted just before that one ...

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

... looks like a good start, but we're missing a fundamental step---a statement of the query requirement. It's as foolhardy to try to write a complex query without a detailed statement of the requirement as it would be to build a house without an architectural plan.

So let's see a complete statement of the requirement.