SQL manipulation Primary Key vs Foreign Key

I’m on excersice 6 and it cannot find table classes and students, so I’m stuck, this is my query:

FROM students
JOIN classes
   ON classes.id = students.class_id;

the error is: Error: near line 1: no such table: students


I’m getting the same error on several occasions. The error keeps re-appearing even when nothing is entered. I submitted a bug report.

I got the same error message since my data was still attached to the previous page. I exited the lesson and re-entered and it worked.

Try the below code
FROM classes
JOIN students
ON classes.id = students.class_id;

1 Like

It works!! thanks you! I think the order is the problem.