题解 | 关联+子查询
使用子查询的方式找出属于Action分类的所有电影对应的title,description
https://www.nowcoder.com/practice/2f2e556d335d469f96b91b212c4c203e
SELECT a1.title, a1.description FROM film a1 LEFT JOIN ( SELECT a4.film_id, a3.name FROM category a3 LEFT JOIN film_category a4 ON a3.category_id=a4.category_id ) a2 ON a1.film_id=a2.film_id WHERE a2.name='Action'
关联+子查询
子查询得出需要的信息再用连接连起来输出即可