Simple MS SQL query - If exists in one table need to return Y else N : I have 2 tables.   One table (employeemaster) contains all of my employees in the company.  Primary key = EmpNo

The other table (employeeNoTime) contains a smaller list of employees that have no benefits. Primary key = EmpNo

I want to query that will return 2 columns.  The EmployeeNo, and Y or N

Yif the employee number is in the EmployeeNoTime table.  Any suggestions?