0
This error is showing.
JOINING TABLES SQL SELECT students.id, students.name AS student, teachers.last_name AS teacher FROM students JOIN teachers ON students.teacherid = teachers.id ORDER BY students.id; : column students.name does not exist LINE 1: SELECT students.id, students.name AS student, teachers.last_... ^ The column name "name" does not exist in the "students" table. Use the correct column name or check if it exists in the table.
3 odpowiedzi
+ 4
Read the error: Is there a column called name? Or is it firstname and lastname? (Or something else?)
+ 1
Your question is...?
+ 1
Open your DB and see the name of the column. Keep in mind while sql itself is case-insensitive, columns names 'name' and 'Name' are different.