We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
May I know what does this part mean? Why use W1 with W and P1 with P?Thank you so much!!!
SELECT MIN(coins_needed)
FROM WANDS AS W1
INNER JOIN WANDS_PROPERTY AS P1 ON W1.code = P1.code
WHERE W1.power = W.power AND P1.age = P.age)
Ollivander's Inventory
You are viewing a single comment's thread. Return to all comments →
May I know what does this part mean? Why use W1 with W and P1 with P?Thank you so much!!! SELECT MIN(coins_needed) FROM WANDS AS W1 INNER JOIN WANDS_PROPERTY AS P1 ON W1.code = P1.code WHERE W1.power = W.power AND P1.age = P.age)