This error is showing. | Sololearn: Learn to code for FREE!
Novo curso! Todo programador deveria aprender IA generativa!
Experimente uma aula gr√°tis
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.

17th May 2024, 5:09 AM
Div Anand
Div Anand - avatar
3 Respostas
+ 4
Read the error: Is there a column called name? Or is it firstname and lastname? (Or something else?)
17th May 2024, 8:54 AM
Ausgrindtube
Ausgrindtube - avatar
+ 1
Your question is...?
17th May 2024, 7:21 AM
Wong Hei Ming
Wong Hei Ming - avatar
+ 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.
21st May 2024, 9:31 PM
john ds
john ds - avatar