简单的方法

SELECT f.title, f.description
FROM film f,film_category fc,category c
WHERE f.film_id=fc.film_id
AND fc.category_id=c.category_id
AND c.name LIKE "Action"