Linked server[
^] is all what you need. See:
How to Create a Linked Server[
^]
After taht you'll be able to get data from that linked server:
select tr.paycode, tr.in1, em.out2
from tbltimeregister tr inner join [testhr].[dbo].[employeemaster] em on tr.paycode=em.employee_id