子查询，可以用in或者exists 

select f.title,f.description from film f where f.film_id in(select fc.film_id from category c,film_category fc
where fc.category_id=c.category_id and c.name='Action')