使用子查询,就比较简单了,先从电影表选出要求字段,然后让 film_id 与 关联表 id 对应的同时,让类型等于 Action
select title, description
from film
where film_id in (
select film_id
from film_category
where category_id = (
select category_id
from category
where name = 'Action'
)
)