题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#

SELECT
    T.title,
    T.description
FROM
    film T
WHERE 
    T.film_id IN 
(
    SELECT 
        t1.film_id 
    FROM 
        film_category t1 
    left join 
        category t2 
    on t1.category_id = t2.category_id 
    where t2.name = 'Action'
)