This error is showing. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson

This error is showing.

JOINING TABLES SQL SELECT, AS student, teachers.last_name AS teacher FROM students JOIN teachers ON students.teacherid = ORDER BY; : column does not exist LINE 1: SELECT, 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 Answers
+ 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 - 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