错误代码： 1054 Unknown column 'course' in 'field list'

1、错误描述

1 queries executed, 0 success, 1 errors, 0 warnings

查询：SELECT stu_name, course, score FROM t_student_info s LIMIT 0, 1000

错误代码： 1054
Unknown column 'course' in 'field list'

执行耗时   : 0 sec
传送时间   : 0 sec
总耗时      : 0 sec

2、错误原因

SELECT 
  stu_name,
  course,
  score 
FROM
  t_student_info s 
  AND t_score_info sc 
WHERE s.stu_id = sc.stu_id 
GROUP BY stu_id 

       无法区别course字段是哪张表的

3、解决办法

SELECT   
  s.stu_name,  
  sc.course,  
  sc.score   
FROM  
  t_student_info s   
  AND t_score_info sc   
WHERE s.stu_id = sc.stu_id   
GROUP BY stu_id