The below code used to JOIN the
two tables without using "UNION" function.
SELECT eid, ename FROM Emp
UNION SELECT eid, ename FROM Emp2
COALESCE(dbo.emp1.ename, dbo.emp2.ename)AS Value
FROM dbo.emp1
FULL OUTER JOIN dbo.emp2 ON dbo.emp2.eid = dbo.emp1.eid
SELECT eid, ename FROM Emp
UNION SELECT eid, ename FROM Emp2
Alternative code
SELECT COALESCE(dbo.emp1.eid, dbo.emp2.eid) AS ID,COALESCE(dbo.emp1.ename, dbo.emp2.ename)AS Value
FROM dbo.emp1
FULL OUTER JOIN dbo.emp2 ON dbo.emp2.eid = dbo.emp1.eid