Tuesday, July 2, 2013

Alternative to "UNION" function in SQL Server

The below code used to JOIN the two tables without using "UNION" function.

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