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`