如题,套娃。
SELECT title,description
FROM film
WHERE film_id IN
(
SELECT film_id
FROM film_category
WHERE category_id=(
SELECT category_id
FROM category WHERE name='Action')
);
如题,套娃。
SELECT title,description
FROM film
WHERE film_id IN
(
SELECT film_id
FROM film_category
WHERE category_id=(
SELECT category_id
FROM category WHERE name='Action')
);