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

考察多个表连接