from film
where film_id in (select film_id from category c inner join film_category fc
                      on c.category_id=fc.category_id
                     where c.name="Action");