left join + is null 实现查询

select a.film_id,a.title from film a left join film_category b 
on a.film_id = b.film_id 
where b.category_id is null;