在单列中存储子数据

我有以下表格:

 CREATE TABLE titles (
     id INTEGER,
     title VARCHAR(255)
   );
   INSERT INTO titles (id, title) VALUES (1, "Mars Attacks!");
   INSERT INTO titles (id, title) VALUES (2, "Da Vinci Code");

   CREATE TABLE GenreName (
     id INTEGER,
     name VARCHAR(255)
   );

   INSERT INTO GenreName (id, name) VALUES (1, "Action");
   INSERT INTO GenreName (id, name) VALUES (2, "Adventure");
   INSERT INTO GenreName (id, name) VALUES (3, "Comedy");
   INSERT INTO GenreName (id, name) VALUES (4, "Science-Fiction");
   INSERT INTO GenreName (id, name) VALUES (5, "Thriller");

   CREATE TABLE Genre (
     title INTEGER,
     genre INTEGER
   );
   INSERT INTO Genre (title, genre) VALUES (1, 1);
   INSERT INTO Genre (title, genre) VALUES (1, 3);
   INSERT INTO Genre (title, genre) VALUES (1, 4);
   INSERT INTO Genre (title, genre) VALUES (2, 1);
   INSERT INTO Genre (title, genre) VALUES (2, 5);

Id            Title                  Genre
1             Mars Attacks!          Action, Comedy, Science-Fiction
2             Da Vinci Code          Action, Thriller

我一直坚持用递归方式选择数据。

我有一个 DBFiddle