select f.film_id, f.title
from film f left join film_category fc
on f.film_id=fc.film_id
where fc.category_id is null
select f.film_id, f.title
from film f left join film_category fc
on f.film_id=fc.film_id
where fc.category_id is null
牛客博客，记录你的成长
京公网安备 11010502036488号