双子查询方式

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