錯誤碼： 1052 Column 'stu_id' in field list is ambiguous，stu_idambiguous

錯誤碼： 1052 Column 'stu_id' in field list is ambiguous，stu_idambiguous

1、錯誤描述

1 queries executed, 0 success, 1 errors, 0 warnings查詢：select stu_id, (SELECT stu_name FROM t_student_info t WHERE t_student_info.stu_id = t.stu_id) stu_name from t_student_info t, t_...錯誤碼： 1052Column 'stu_id' in field list is ambiguous執行耗時   : 0 sec傳送時間   : 0 sec總耗時      : 0 sec

2、錯誤原因

SELECT   stu_id,  (SELECT     stu_name   FROM    t_student_info t   WHERE t_student_info.stu_id = t.stu_id) stu_nameFROM  t_student_info t,  t_score_info t0 WHERE t.`stu_id` = t0.`stu_id` 

3、解決辦法