题目 解答 方法一:没有使用join查询 select f.film_id,f.title from film as f where f.film_id not in (select film_id from film_category); 方法二:使用join查询 select f.film_id,f.title from film as f left join film_category as fc on f.film_id=fc.film_id where fc.category_id is null;