If what you are trying to do is retrieve only the emp_id and emp_name of the employees and you are not selecting any field from table2. You only need...
a.col1 Not in(Select b.col1 from table2)group
You can use PIVOT or you can use Case statements to do your move if you can.
Did you try thisselect
from tblEmployee a
inner join tblEmploy_type_link b
on a.emp_id = b.emp_id
I would suggest you use the DATEADD function If you are trying to calculate the total in days, months, years etc...
Separate names with a comma.