SELECT f.film_id, f.title
FROM film f 
LEFT JOIN film_category fc 
    USING (film_id)
WHERE fc.category_id IS NULL