linq中的join查询

linq中使用join查询，Table跟List

 from t in dtAllEmp.AsEnumerable()
                    join t2 in list.AsEnumerable()
                    on t.Field<string>("Empid") equals t2.Empid
                    orderby t2.CreateDate descending
                    select new
                    {
                        Empid = t.Field<string>("Empid"),
                        EmpName = t.Field<string>("EmpName"),
                        DeptId = t.Field<string>("DeptId"),
                        DeptName = t.Field<string>("DeptName"),
                        AccountId = t2.AccountId,
                        AddEmpid = t2.AddEmpid,
                        CreateDateStr = t2.CreateDateStr
                    };