表子查询，表连接之后作为筛选条件

-- 注意文本需要加 " ",以及表连接之后子查询连接时才需要别名 select t.title,t.description from film as t where t.film_id in (select e.film_id from category as c right join film_category as e on c.category_id=e.category_id where c.name="Action");