根据条件SQL Server选择一列

I have a situation like this:

我有这样的情况：

SELECT 
   fName, 
   lName
FROM employee as e
join payroll as p ON p.frn_employeeid = e.employeeId
SELE