使用子查询的方式找出属于Action分类的所有电影对应的title,description
SQL练习题30(中等):
--子查询
select a.title,a.description
from film a
where a.film_id in
(select b.film_id
from film_category b
where b.category_id in (
select c.category_id
from category c
where c.name='Action')
);
--左连接
select a.title,a.description
from film 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';