from film 
where film_id not in (select film_id from category c inner join film_category as fc 
                      on c.category_id=fc.category_id)