[프로그래머스 - ORACLE] 우유와 요거트가 담긴 장바구니

---

CREATE 문

CREATE TABLE CART_PRODUCTS (
ID				NUMBER,
CART_ID				NUMBER,
NAME				VARCHAR(30)
PRICE				NUMBER
)

 

---

• 내 풀이

SELECT
    A.CART_ID
FROM CART_PRODUCTS A INNER JOIN CART_PRODUCTS B
ON A.CART_ID = B.CART_ID
AND A.NAME = 'Milk'
AND B.NAME = 'Yogurt'
ORDER BY CART_ID ASC