Tamil,
Emp_no is Unique in both the tables.

akkerend,
Do u think Using UNION instead of UNION ALL could give wrong result ???