题解 | 使用子查询的方式找出属于Action分类的所有电影对应的title,description
select title,description from( select t2.category_id,t2.name,t3.film_id,t1.title,t1.description from category as t2 inner join film_category as t3 on t2.category_id = t3.category_id inner join film as t1 on t1.film_id = t3.film_id) as t where category_id = 1;
顶点软件二面4人在聊
查看6道真题和解析
