错误代码： 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_... 错误代码： 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`
3、解决办法
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。