join大法

select title,description
from (
    select ff.title,ff.description,c.name
    from film_category fc
    join film ff
    on fc.film_id=ff.film_id
    join category c
    on fc.category_id =c.category_id
) f 
where f.name='Action';