双子查询方式
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"))
双子查询方式
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"))