[Level 4] 우유와 요거트가 담긴 장바구니

나며기·2021년 10월 31일
0

programmers

목록 보기
98/111
post-thumbnail
SELECT Yogurt.CART_ID
FROM (SELECT CART_ID
     FROM CART_PRODUCTS
     WHERE NAME = 'Yogurt') AS Yogurt,
     (SELECT CART_ID
     FROM CART_PRODUCTS
     WHERE NAME = 'Milk') AS Milk
WHERE Yogurt.CART_ID = Milk.CART_ID
profile
PLUS ULTRA

0개의 댓글