This is the first time I post something, hopefully I haven’t done it wrong.
My question has to do more with simple logic. I am learning about JOIN clauses. But for me it seems counter-intuitive the way you do JOIN (unless I am getting it wrong all together!)
So to use a real world example, if I am baking a cake and I want to ‘join’ sugar into the mix I don’t pour the mix into the sugar but instead the sugar into the mix.
See this exercise and correct answer:
ON plans.id = premium_users.membership_plan_id;
The exercise mentions to join plans and premium_users. So in my head that means ‘pour premium into plans’. But the answer seems to point at doing it the other way around? I can’t get my head around it!