SELECT CONVERT(varchar(15),EmployeeID) AS EmployeeID
, LastName+', '+FirstName AS EmployeeFullName
SELECT emp_id AS EmployeeID
, lname+', '+fname AS EmployeeFullName
, hire_date AS HireDate
ORDER BY 2
That is the best way if the two databases are on the same server. If they are on different servers, then you will need to create a linked server connection and use the OPENQUERY statement to access the remote data.
If it's not practically useful, then it's practically useless.