1、错误描述
2、错误原因
在拼接SQL语句时,给t_stu_amount 和t_tea_info 取别名时,都取c
... from t_stu_info a,t_stu_amount c,t_tea_info c
导致数据库表别名重复
3、解决办法
将两个表的别名改为不一样的,如 ... from t_stu_info a,t_stu_amount c,t_tea_info o
1、错误描述
在拼接SQL语句时,给t_stu_amount 和t_tea_info 取别名时,都取c
... from t_stu_info a,t_stu_amount c,t_tea_info c
导致数据库表别名重复
3、解决办法
将两个表的别名改为不一样的,如 ... from t_stu_info a,t_stu_amount c,t_tea_info o