How to link many entities to one as a result?

Question

MySQL

There is a movie table with a unique id. There are comments from their unique id, film_id is the film's unique key and comment text. How to display all comments under Movie field name?

For example:

|Название фильма.Текст|  Название фильма.Ключ  |
 |-------------------------|----------------------------|
 |Комментарий один        | Ключ комм   1        |
 |-------------------------|----------------------------|
 |Комментарий два          | Ключ комм  2          |

Answer 1

SELECT for_output
FROM ( SELECT name AS film_name, name AS for_output
       FROM films
     UNION ALL
       SELECT films.name, comments.comment
       FROM films 
       JOIN comments USING (film_id) ) total
ORDER BY film_name, film_name <> for_output