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

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

1. 三个表连接
2. where后面使用子查询找出分类名字是Action 的电影