SQL错误Duplicate column name 'NAME'名字重复应使用别名

最新推荐文章于 2023-04-19 11:41:25 发布

原创最新推荐文章于 2023-04-19 11:41:25 发布 · 6.3k 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

25 篇文章

订阅专栏

SQL错误Duplicate column name 'NAME'名字重复应使用别名

<select id="getCurrentAndInformation" resultType="StudentCurrent">
   SELECT
   a.name AS "studentinf.name",
   a.gender AS "studentinf.gender",
   a.departmentname AS "studentinf.departmentname",
   a.roomnumber AS "studentinf.roomnumber",
   a.major AS "studentinf.major",
   a.bottomphoto AS "studentinf.bottomphoto",
   a.grade AS "studentinf.grade",
   a.dormitoryname AS "studentinf.dormitoryname",
   <include refid="studentCurrentColumns"/>
   FROM huigou_student_information a
   left  join
   (SELECT *,max(uploadTime) as uploadTime   from huigou_student_current WHERE del_flag="0" GROUP BY studentInformationId)  sc on a.studentid=sc.studentinformationid
   WHERE a.studentid = #{studentid}
</select>

修改：

<select id="getCurrentAndInformation" resultType="StudentCurrent">
   SELECT
   a.name AS "studentinf.name",
   a.gender AS "studentinf.gender",
   a.departmentname AS "studentinf.departmentname",
   a.roomnumber AS "studentinf.roomnumber",
   a.major AS "studentinf.major",
   a.bottomphoto AS "studentinf.bottomphoto",
   a.grade AS "studentinf.grade",
   a.dormitoryname AS "studentinf.dormitoryname",
   <include refid="studentCurrentColumns"/>
   FROM huigou_student_information a
   left  join
   (SELECT *,max(uploadTime) as uploadTime1   from huigou_student_current WHERE del_flag="0" GROUP BY studentInformationId)  sc on a.studentid=sc.studentinformationid
   WHERE a.studentid = #{studentid}
</select>