嘿，这个坑很多人都踩过！SQL的执行顺序是有讲究的：WHERE子句会在SELECT子句之前运行，这意味着你在SELECT里定义的字段别名（比如你的Total），在WHERE阶段还没被系统识别出来，直接用肯定会报“无效列名”的错误。结合你的查询语句，给你几个靠谱的解决方案：

1. 使用子查询（最通用的方案） #

把你的原始查询包装成一个子查询，在外层查询里就可以直接使用别名了。注意你的查询里用到了SUM()聚合函数，必须加上GROUP BY子句，不然会报错哦。

示例代码：

SELECT *
FROM (
    SELECT 
        employee_tbl.emp_maxid, 
        emp_name AS 'Employee Name', 
        Designation_tbl.Des_Name AS Designation, 
        emp_LabourID, 
        emp_IBAN, 
        emp_monthlysalary AS Salary, 
        0 AS commission, 
        ISNULL(emp_monthlysalary - sum(S.Paid), emp_monthlysalary) AS Total 
    FROM dbo.employee_tbl 
    INNER JOIN dbo.Designation_tbl ON Designation_tbl.Des_id = employee_tbl.Des_id 
    LEFT JOIN SalaryProcessLog_tbl S ON S.emp_maxid = employee_tbl.emp_maxid 
    WHERE (emp_deleted = 0 OR emp_deleted IS NULL)
    GROUP BY employee_tbl.emp_maxid, emp_name, Designation_tbl.Des_Name, emp_LabourID, emp_IBAN, emp_monthlysalary
) AS EmpSalary
WHERE EmpSalary.Total > 5000; -- 这里就能直接用别名筛选了

2. 使用CTE（公共表达式，可读性更强） #

和子查询原理一样，但结构更清晰，适合复杂查询场景。

示例代码：

WITH EmpSalary AS (
    SELECT 
        employee_tbl.emp_maxid, 
        emp_name AS 'Employee Name', 
        Designation_tbl.Des_Name AS Designation, 
        emp_LabourID, 
        emp_IBAN, 
        emp_monthlysalary AS Salary, 
        0 AS commission, 
        ISNULL(emp_monthlysalary - sum(S.Paid), emp_monthlysalary) AS Total 
    FROM dbo.employee_tbl 
    INNER JOIN dbo.Designation_tbl ON Designation_tbl.Des_id = employee_tbl.Des_id 
    LEFT JOIN SalaryProcessLog_tbl S ON S.emp_maxid = employee_tbl.emp_maxid 
    WHERE (emp_deleted = 0 OR emp_deleted IS NULL)
    GROUP BY employee_tbl.emp_maxid, emp_name, Designation_tbl.Des_Name, emp_LabourID, emp_IBAN, emp_monthlysalary
)
SELECT *
FROM EmpSalary
WHERE Total > 5000; -- 直接使用别名

3. 用HAVING替代WHERE（针对聚合字段的特殊场景） #

因为你的Total字段是基于SUM()聚合函数计算出来的，如果你只是想筛选这个聚合后的结果，可以直接把Total对应的表达式放到HAVING子句里——HAVING是专门用来过滤分组后结果的，它能识别聚合函数。

示例代码：

SELECT 
    employee_tbl.emp_maxid, 
    emp_name AS 'Employee Name', 
    Designation_tbl.Des_Name AS Designation, 
    emp_LabourID, 
    emp_IBAN, 
    emp_monthlysalary AS Salary, 
    0 AS commission, 
    ISNULL(emp_monthlysalary - sum(S.Paid), emp_monthlysalary) AS Total 
FROM dbo.employee_tbl 
INNER JOIN dbo.Designation_tbl ON Designation_tbl.Des_id = employee_tbl.Des_id 
LEFT JOIN SalaryProcessLog_tbl S ON S.emp_maxid = employee_tbl.emp_maxid 
WHERE (emp_deleted = 0 OR emp_deleted IS NULL)
GROUP BY employee_tbl.emp_maxid, emp_name, Designation_tbl.Des_Name, emp_LabourID, emp_IBAN, emp_monthlysalary
HAVING ISNULL(emp_monthlysalary - sum(S.Paid), emp_monthlysalary) > 5000;

总结一下：如果是筛选普通字段的别名，子查询/CTE是首选；如果是筛选聚合后的字段别名，用HAVING会更直接。

内容的提问来源于stack exchange，提问作者user2510547