This community-built FAQ covers the “Combining Tables Manually” exercise from the lesson “Multiple Tables”.
Paths and Courses
This exercise can be found in the following Codecademy content:
Web Development
Data Science
Learn SQL
FAQs on the exercise Combining Tables Manually
Join the Discussion. Help a fellow learner on their journey.
Ask or answer a question about this exercise by clicking reply (
) below!
Agree with a comment or answer? Like (
) to up-vote the contribution!
Need broader help or resources? Head here.
Looking for motivation to keep learning? Join our wider discussions.
Learn more about how to use this guide.
Found a bug? Report it!
Have a question about your account or billing? Reach out to our customer support team!
None of the above? Find out where to ask other questions here!
Hello,
Thanks for this free course
Example here https://www.codecademy.com/courses/learn-sql/lessons/multiple-tables/exercises/what-is-join
Is Wrong answer
Using the tables displayed, what is the description of the magazine ordered in order_id 1?
order_id 1 refer to subscription_id 2 not 3 as you write in hint and answer is Politics Magazine not Sports Magazine.
I hope you fix this, very thanks have a nice day.
and aslo example two in same lesson
2 Likes
There is some problem while executing this program. When I hit Run, the command doesnt execute and I am stuck in this page. Please fix this.
3 Likes
How do I move on to the next lesson because I’m stuck in lesson 2. I typed the correct answer from lesson 1 table and I also typed in the answer given in the solution, still can’t go to lesson 3.
1 Like
I am having an issue on lesson 2 of this module as well. The part on the right side showing the tables never loads, and I’m unable to get past it. Any ideas on what might be going wrong?
1 Like
Click on the bottom right where it says get unstuck. Then click on solution - get code solution - replace with solution.
1 Like
Does anyone know how to fix this? The replace code with the solution is not working in safari or chrome. So I’m stuck on this lesson and can’t progress.
I may or may not have found the solution to this problem
first, I clicked the “Course Menu”, then click on the “Combining Tables Manually”.
It finally accepted my solution.
It worked for me, but might not for others. hope this works for everyone, though.
When we combine tables, are we only combing for the duration of the query or does this create a lasting connecting?
then you have to run wrong answer))) you will move on next step)))
For #1 and #2 , you are NOT supposed to write the SQL code. You’re supposed to type in the ANSWER to the question. So, you type Sports Magazine on the first line (of the code editor), and then hit the RUN button. Then you type Joe Schmo on the second line, and hit the RUN button again. So, that takes care of question #1 and #2.
The question really should be explained better, because you think you are supposed to enter code. But, you are supposed to type in the ANSWER to the question.
1 Like
