If i understand you well...
...this should do the work:
var qry = from ec in entities.EmployeeCategories.Where(x=>x.EmployeeCategory=="A")
join es in entities.EmployeeStatus on ec.Emp_Id equals es.Emp_Id
group es by new{Cat=ec.EmployeeCategory, EmpId= es.Emp_Id} into grp
select new
{
Cat = grp.Key.Cat,
EmpId = grp.Key.EmpId,
Es_Id = grp.Max(x=>x.id)
};
Result:
Cat EmpId Es_Id
A 22 4