题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#

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

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