有一个表是多余的

select film_id,title
from 
(select * from film a left join film_category c on a.film_id=c.film_id where c.category_id is null)