EmployeeId EmployeeName 12 vivek 16 siva 26 prasanth 34 mahesh
Employeeid Salary 13 45000 14 12000 16 50000 26 58222
Employeeid Status 12 N 16 Y 26 Y 34 N
select t1.employeeid,case when isnull(t2.salary,0) =0 then 'N' else 'Y' end as 'Status' from table1 t1 left outer join table2 t2 on t2.employeeid=t1.employeeid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)