Id(p.k)    Department
1           Admin
2           Hr
3           Sales

Id  Email              Prioity(F.K)
1   abc@gmail.com          1
2   xyz@gmail.com          2
3   lmn@gmail.com          3
4   Jeams@gmail.com        3
5   ANder@gmail.com        3

public IEnumerable<Ems_UserFat_Tab> GetUserFatData()
    {
        var x = from n in db.EMS_USER_MASTER
                join prio in db.Ems_priority_Master on n.USER_PRIORITY equals prio.User_Priority_ID
                where n.ROLE_ID==3  &&  prio.User_Priority_ID==1
                select new Ems_UserFat_Tab
                {

               Sh_Email= n.EMAIL,

                };

        return x.ToList();
    }