错误代码: 1052 Column 'stu_id' in field list is ambiguous

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_...

错误代码: 1052
Column '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_name
FROM
  t_student_info t,
  t_score_info t0 
WHERE t.`stu_id` = t0.`stu_id` 

      无法区别stu_id是属于哪张表,导致模糊不清


3、解决办法

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


©️2020 CSDN 皮肤主题: 代码科技 设计师:Amelia_0503 返回首页