[SELECT/LEVEL2] 업그레이드 된 아이템 구하기 (MySQL)

MySQL

SELECT ITEM_ID, ITEM_NAME, RARITY
FROM ITEM_INFO 
WHERE ITEM_ID IN (SELECT B.ITEM_ID
                    FROM ITEM_INFO A, ITEM_TREE B
                    WHERE A.ITEM_ID = B.PARENT_ITEM_ID
                    AND A.RARITY = 'RARE' )
ORDER BY ITEM_ID DESC