所以我有三个单独的表,分别标记为导演、工作室和电影。
导演专栏: id, name, dob, nationality, gender
.
工作室栏目:id, name, founding date, and director_id
(外键director_id
)
电影:ID, name, length, studio_id
(外键studios_id
)
我必须找到所有导演电影的导演,名字叫觉醒,但我不知道如何正确使用外键。我想出的最好的是
SELECT name, studio_id FROM studios WHERE name = "awakening"
我不知道我在做什么。请帮忙。
请尝试在查询中使用内部连接
SELECT d.id, d.name FROM director d INNER JOIN studios s ON d.id = s.director_id INNER JOIN movie m ON s.id = m.studio_id WHERE m.name = "awakening";
SELECT Movies.name as movie_name, Directors.name as director_name
FROM Movies
JOIN Studios ON (Movies.studio_id = Studios.id)
JOIN Directors ON (Studios.director_id = Directors.id)
WHERE Movies.name = 'awakening';