I found this code on a different thread and tried it.
ON subscriptions.subscription_id = orders.subscription_id;
ON subscriptions.subscription_id = orders.subscription_id
WHERE description_id = 3;
It doesn’t seem to work, can anyone help me figure out why?
Says description instead of subscription in the last line?
Hi, there! This question was bugging me too, and I saw your answer and played around with it. Turns out this is mostly correct, except for the last line:
WHERE description = “Fashion Magazine”;
This is because there is no “description_id” in the table, just “description”, and the value is not an integer but a string such as “Political Magazine”, “Fashion Magazine”, etc. Hope this helps.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.