题解 |查询方式找出没有分类的电影id以及名称#

select film_id,title
from film
where film_id not in
(
    select f.film_id
    from film f,category c,film_category fc
    where f.film_id=fc.film_id
    and c.category_id=fc.category_id
)

没有用到join,但也是一种思路