方法)子查询
- 使用子查询
- 属于Action分类
SELECT f.title, f.description FROM film AS f, film_category AS fc WHERE f.film_id = fc.film_id AND fc.category_id IN ( SELECT category_id FROM category WHERE name = 'Action');
SELECT f.title, f.description FROM film AS f, film_category AS fc WHERE f.film_id = fc.film_id AND fc.category_id IN ( SELECT category_id FROM category WHERE name = 'Action');