如题,套娃。

SELECT title,description
FROM film
WHERE film_id IN
(
SELECT film_id
FROM film_category
WHERE category_id=(
    SELECT category_id
    FROM category WHERE name='Action')
    );