problema con query sql!

[alpynet]

ciao, prova questa:

SELECT movies.*
FROM movies INNER JOIN (cinema INNER JOIN cinema_movie ON cinema.id_cinema = cinema_movie.id_cinema) ON movies.id_movie = cinema_movie.id_movie
WHERE cinema.name="nome cinema";