select title,description
from film
where film_id in
(
select film_id
from category a 
left join film_category b 
on a.category_id = b.category_id
where a.name = 'Action'
)

将所有分类为Action的电影id找出来，然后作为条件被电影表筛选