问题

我在我的 SQL 中遇到了问题，不知道该如何解决。
有人能提供一些帮助和提示吗？

字段列表中的 'student_id' 在字段列表中是模糊的

SELECT student_id, student.first_name, student.last_name, subject.label, student_score
FROM score
INNER JOIN student as stdtab on stdtab.id = student_id
INNER JOIN subject as stab on stab.id = subject_id

英文:

Im having problems on my sql and dont know how to fix it.
Can anyone provide some help and tips for it?

Column 'student_id' in field list is ambiguous

SELECT student_id, student.first_name, student.last_name, subject.label, student_score 
FROM score 
INNER JOIN student as stdtab on stdtab.id = student_id
INNER JOIN subject as stab on stab.id = subject_id

答案1

得分: 1

这个错误意味着查询中存在多个表中都存在student_id列名，请在student_id之前使用表名。就像这样（如果student_id在名为student的表中）：

SELECT student.student_id, student.first_name, student.last_name, subject.label, student_score 
FROM score 
INNER JOIN student as stdtab on stdtab.id = student.student_id
INNER JOIN subject as stab on stab.id = subject_id

英文:

This error means the student_id column name exists in more then one table in the query, use the table name before student_id. Like this (if student_id is in table student):

SELECT student.student_id, student.first_name, student.last_name, subject.label, student_score 
FROM score 
INNER JOIN student as stdtab on stdtab.id = student.student_id
INNER JOIN subject as stab on stab.id = subject_id

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。