2022-2-14-Java-多次指定列错误

 

 spring文件报错：Exception is com.microsoft.sqlserve.jdbc.SQLServerException:多次为'XXXXX'指定了列'xx'。

报错原因：sql语句查询时，多次找到重复字段。虽然对表取了别名，但在分页查询时两张表合并成了*，有重复字段时导致无法识别。

解决办法：修改其中的重复字段名。

例子：报错时候语句：

SELECT
   *
FROM
    Scs_BoardBasicDataHandle AS main
LEFT JOIN  Scs_ShipInfo AS ssi ON ssi.ship_id = main.ship_id
LEFT JOIN Hrms_Emp AS emp ON main.emp_id = emp.empid
JOIN (......
改为：

SELECT
    main.emp_id as EmpID,
    emp.EmpName as EmpName
FROM
    Scs_BoardBasicDataHandle AS main
LEFT JOIN  Scs_ShipInfo AS ssi ON ssi.ship_id = main.ship_id
LEFT JOIN Hrms_Emp AS emp ON main.emp_id = emp.empid
JOIN (......
为其指定输出列。