简单联查即可
使用子查询的方式找出属于Action分类的所有电影对应的title,description
https://www.nowcoder.com/practice/2f2e556d335d469f96b91b212c4c203e
select title,description
from (
select fc.film_id,fc.category_id,f.title,f.description
from film f, category c,film_category fc
where f.film_id = fc.film_id
and c.category_id = fc.category_id
and c.name = 'Action'
) as rs;
