第一种方法不应该是连接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);
点赞

相关推荐

牛客网
牛客企业服务