题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#
使用子查询的方式找出属于Action分类的所有电影对应的title,description
http://www.nowcoder.com/practice/2f2e556d335d469f96b91b212c4c203e
使用常规方式查询
/select title,description
from film join film_category
on film.film_id = film_category.film_id
join category
on category.category_id = film_category.category_id
where category.name = 'Action'/
#使用子查询方式查询
select title,description
from (select category_id
from category
where category.name = 'Action') as N join film_category
on N.category_id = film_category.category_id
join film
on film_category.film_id = film.film_id
三奇智元机器人科技有限公司公司福利 86人发布