when i answer then i saw the reported date.
so anyway will tell me the problem doing with group by ?:confused:
The process is simple. First Join these two tables and then sum Age of two employees.
e1.NAME,SUM(e1.Age+ e2.Age)FROM #emp1 e1 JOIN...
Separate names with a comma.