mysql - 从表 A 中获取项目，该表通过表 B 链接到表 C。三重联接？

Question

假设一个网站根据流行故事发布的媒体格式对其进行分类。其数据库由以下表格组成:

应该使用什么样的查询来检索以电影等形式发布的所有故事标题？

我想做这样的事情，但怀疑有更好的方法:

SELECT `story_id`
FROM `links` INNER JOIN `media`
  ON `links`.`medium_id` = `media`.`medium_id`
  WHERE `media`.`medium_name` = :medium_name"

for every retrieved story_id
{
    SELECT `story_summary` FROM `stories` WHERE `story_id` = :story_id
}

任何帮助将不胜感激!

Answer 1

SELECT
    s.story_title
FROM MEDIA as m
LEFT JOIN LINKS as l ON l.medium_id = m.medium_id
LEFT JOIN STORIES as s ON s.story_id = l.story_id
WHERE m.medium_name = 'movie'