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

/* -- 使用left join select a.title, a.description from film as a # left join film_category b on a.film_id = b.film_id # left join category c on b.category_id = c.category_id # where c.name = 'Action' */ -- 子查询 select f.title,f.description from film as f inner join film_category fc on f.film_id = fc.film_id where fc.category_id = ( select category_id from category where name = 'Action' )