Hello ,
Why not you use simple join .
create table #tmp (empid varchar(50),username varchar(50),Acount int)
insert into #tmp values('2035','saran',5662)
insert into #tmp values('3027','Sashi kumar',7063)
select * from #tmp
create table #tmp1 (empid varchar(50),Ccount int )
insert into #tmp1 values('2035' , 5663)
select a.empid , a.acount , b.ccount from #tmp a inner join #tmp1 b on a.empid=b.empid
Out put will be
empid acount ccount
2035 5662 5663