select f.film_id,f.title
from film as f 
left join film_category as fc on fc.film_id=f.film_id 
where fc.category_id is null;

主要考察左连接，两个表相连即可