update CustomerOrderPermission
set CustomerOrderPermission.[EndTime] = CAST(GETDATE()-1 AS DATE)
from CustomerOrderPermission
inner join Employee on
CustomerOrderPermission.EmployeeId = Employee.EmployeeId
and (Employee.Status!=1 or Employee.IsActive=0) and CustomerOrderPermission.[EndTime] is null
参考文章(如何在SQL中使用JOIN执行UPDATE语句?_asdfgh0077的博客-CSDN博客_update语句用join)