牛客SQL练习-30-使用子查询的方式找出属于Action分类的所有电影对应的title,description

SELECT
	f.title,
	f.description 
FROM
	film AS f 
WHERE
	f.film_id IN (
	SELECT
		fc.film_id 
	FROM
		film_category AS fc 
WHERE
	fc.category_id IN ( SELECT c.category_id FROM category AS c WHERE c.NAME = 'Action' ));

方法二: 采用内连接

SELECT
	f.title,
	f.description 
FROM
	film f,
	film_category fc,
	category c 
WHERE
	f.film_id = fc.film_id 
	AND fc.category_id = c.category_id 
	AND c.NAME = 'Action'