第一种方法不应该是连接category表和film_category表吗 如下： select f.film_id , f.title from film as f where f.film_id not in (select fc.film_id from category as c inner join film_category as fc on c.category_id = fc.category_id);