我的Query

  

1055 SELECT列表的表达式＃2不在GROUP BY子句中，并且   包含未聚合的列'dms.HrAttLogsFormatted.ScanIn'，该列为   在功能上不依赖于GROUP BY子句中的列；这是   与sql_mode = only_full_group_by

不兼容

查询：

SELECT
    Employee.Id as Id,Employee.FingerId as FingerId,Employee.Name as Name,Departement.Departement as Departement,EmployeeShift.Shift as Shift,ScanIn
FROM
    HrEmployee as Employee
    LEFT JOIN HrEmployeeShift as EmployeeShift 
        ON Employee.ShiftId = EmployeeShift.Id
    LEFT JOIN CmDept as Departement 
        ON Employee.DeptId = Departement.Id
    LEFT JOIN (
        SELECT
            TableEmployee.FingerId,ScanIn
        FROM
            HrEmployee as TableEmployee,HrAttLogsFormatted
        WHERE
            TableEmployee.FingerId = HrAttLogsFormatted.FingerId
            AND DateIn = '2019-11-04'
        GROUP BY HrAttLogsFormatted.FingerId
    ) AS HrJoinLogs 
        ON Employee.FingerId = HrJoinLogs.FingerId
WHERE
    Employee.Status = 1
    AND Employee.flag = 1
    AND Employee.ShiftId = 1
    AND ScanIn is NULL
GROUP BY
    Employee.Name
ORDER BY
    Employee.Name ASC

有人可以解决吗？