sql script

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