Milk
와 Yogurt
가 담겨있는 테이블을 생성하고, 이 둘을 JOIN
하여 겹치는 CART_ID
를 조회한다
WITH
M AS (
SELECT CART_ID, NAME
FROM CART_PRODUCTS
WHERE NAME = 'Milk'
),
Y AS (
SELECT CART_ID, NAME
FROM CART_PRODUCTS
WHERE NAME = 'Yogurt'
)
SELECT M.CART_ID
FROM M INNER JOIN Y ON M.CART_ID = Y.CART_ID