SQL实战30.使用子查询的方式找出属于Action分类的所有电影对应的title,description

题目

解答

方法一：未使用子查询

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

方法二：使用子查询

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