Temp Table

Create Table #MyTempTable (
    EmployeeID int,
    Name varchar(100)
);

Insert Into #MyTempTable SELECT dbo.Employee.Id as EmployeeID, dbo.Table_1.Name as Name
FROM   dbo.Employee INNER JOIN
             dbo.Table_1 ON dbo.Employee.Id = dbo.Table_1.id

Select EmployeeID, Name from #MyTempTable

Drop Table #MyTempTable