mysql - 使用链接表和源表mysql创建子查询

Question

当我尝试从链接表创建查询并且它有两个源表时，我收到错误。当我在 access 中运行它时，它实际上工作得很好，但是 mysql 产生了一个错误，指出我需要添加一个 ( 但我不知道在哪里。

    SELECT movie.movie_name, cast.person_id, cast.movie_id, people.first_name
    FROM people INNER JOIN (movie INNER JOIN [cast] ON movie.movie_id = cast.movie_id) ON 
people.person_id = cast.person_id
    GROUP BY movie.movie_name, cast.person_id, cast.movie_id, people.first_name;

它指出

SELECT is not valid at this position. Expecting '(' 

但我不知道在哪里添加额外的括号。我尝试了添加父级的不同组合

Answer 1

 SELECT movie.movie_name, cast.person_id, cast.movie_id, people.first_name
    FROM people INNER JOIN cast 
    ON people.person_id = cast.person_id
    INNER JOIN movie
    ON movie.movie_id = cast.movie_id
    GROUP BY movie.movie_name, cast.person_id, cast.movie_id, people.first_name;